Query to find attachments in oracle : fnd attachments tables in oracle apps

Query to find attachments in oracle : fnd attachments tables in oracle apps

In this post , I will share the Query to find attachments in oracle . 'fnd_attached_documents' is the Key table which store all the Attachment related Information's in the Oracle Apps. In this below Example I am sharing the example to find the AP Invoice Attachments in Oracle Payables Application. Please find below Query to find attachments in oracle and important fnd attachments tables in oracle apps

2 Important fnd attachments tables in oracle apps

1.fnd_attached_documents

2.fnd_documents

Query to find attachments in oracle

SELECT i.invoice_num,

v.vendor_name,

v.segment1,

ps.vendor_site_code,

ab.batch_name batch_name,

i.invoice_amount,

ad.amount

i.invoice_date,

ad.accounting_date,

glc.segment3 dept,

glc.segment4 acct

FROM ap_invoices_all i,

ap_suppliers v,

ap_batches_all ab,

ap_invoice_distributions_all ad,

gl_code_combinations glc,

fnd_attached_documents fad,

fnd_documents d,

fnd_documents_tl dtl

WHERE i.vendor_id = v.vendor_id

AND i.vendor_site_id = ps.vendor_site_id

AND i.batch_id = ab.batch_id