How to idenitfy attached expense at line level
SummaryNeed to find query for attached expense at line level
I am trying to create a table which shows the expense line and it's attachment.
Currently I have the output as every attachment related to the expense report submission is displaying.
My current query:
select file_name from fnd_documents_tl
where document_id in (select document_id from fnd_attached_documents
where entity_name = 'AP_INVOICES_ALL' and pk1_value in (select to_char(invoice_id) from ap_invoices_all where invoice_id = '14155'))
Where is the table to look at line level?
Or is there an alternative to looking up the itemised expense line level?