fnd attachments tables in oracle apps

fnd attachments tables in oracle apps

In this post , We will be discuss about fnd attachments tables in oracle apps. fnd attachments tables , help to store the document attached informations in oracle apps. We will be discuss more about , fnd attachments tables. I will share one of the most important fnd attachments tables which do store the fnd attachment details. Here below is the complete about fnd attachments tables in oracle apps.

2 Important Tables of fnd attachments tables in oracle apps

1.fnd_attached_documents

2.fnd_documents

SQL query using fnd attachments tables in oracle apps

SELECT d.url,                                                                                  

                i.invoice_num,

                v.vendor_name,

                v.segment1,

                ps.vendor_site_code,

                ab.batch_name batch_name,                                                                                             

                TO_CHAR (i.invoice_amount, '999999999.99') inv_amt,                  

                i.invoice_date,

                ad.accounting_date,

                glc.segment3 dept,

                glc.segment4 acct

         FROM   ap_invoices_all i,

                ap_suppliers v,                                                                                              

                ap_supplier_sites_all ps,                                                                          

                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                           

         AND    ad.dist_code_combination_id = glc.code_combination_id

         AND    ad.invoice_id = i.invoice_id

         AND    i.invoice_id = fad.pk1_value

         AND    fad.document_id = dtl.document_id

         AND    dtl.document_id = d.document_id

         AND    fad.entity_name = 'AP_INVOICES'

         AND    d.datatype_id = 5;

fnd attachments tables in oracle apps

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