[Documentum] DQL to obtain r_object_id from last version of a document by id (See related posts)

select 
  r_object_id 
from 
  dm_sysobject
where 
  i_chronicle_id in (
                      select 
                        i_chronicle_id 
                      from 
                        dm_sysobject(all) 
                      where 
                        r_object_id = 'YOUR_ID'
                    )