REP Need to get UCM Conetent ID for a Transaction

We have a requirement in our project where we need to get the details of a attachment from approved transaction.

We are using "hrc_txn_header" to generate "Document ID" from the xml cache and then using "DM_DOCUMENT_ID" column from "fnd_documents_tl" table we should be able to get the content item id for that attachment from UCM server, but in our case that field is blank for that transaction.

Is there any way to get the UCM Content ID for approved transaction attachedments.

Thanks,

{removed by admin}