Query to identify the UCM document ID for an Expense Report attachment in BI Publisher

Content

Hi experts,

Based on the document:

How to identify UCM Document ID for an attachment from the Expense Report? (Doc ID 2520471.1)​

I have built a query to obtain the ID of the UCM document to obtain the information of the expense reports with status "ready for payment" I made an example expense report to be able to test my query, however it does not return information trying with other reports of expenses if you return information.

I attach the query that I am using.

 

I appreciate your comments.

Regards.

Cesar.