You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to idenitfy attached expense at line level

Question
14
Views
0
Comments

Summary

Need to find query for attached expense at line level

Content

Hi,

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!