Query to find po attachments in oracle apps

Query to find po attachments in oracle apps

In this post , We will be discuss about , query to find PO attachments in oracle apps. This sql query will help to extract the PO attachment informations. What ever the PO additional informations , we do attach, we can extract these informations using this sql query in oracle apps. This SQL query , will provide the complete PO attachment details. Here below is the detail about Query to find po attachments in oracle apps.

3 Important tables used by Query to find po attachments in oracle apps

 1.po_headers_all

 2.ap_suppliers                                                                                           

 3.ap_supplier_sites_all                                                                  

 4.fnd_attached_documents

 5.fnd_documents

 6.fnd_documents_tl

Detail SQL Query to find po attachments in oracle apps

  SELECT d.url,                                                                                  

                i.segment1 "PO NUMBER",

                v.vendor_name,

                v.segment1,

                ps.vendor_site_code

         FROM   apps.po_headers_all i,

                apps.ap_suppliers v,                                                                                              

                apps.ap_supplier_sites_all ps,                                                                         

                apps.fnd_attached_documents fad,

                apps.fnd_documents d,

                apps.fnd_documents_tl dtl

         WHERE  i.vendor_id = v.vendor_id

         AND    i.vendor_site_id = ps.vendor_site_id

         AND    i.po_header_id = fad.pk1_value

         AND    fad.document_id = dtl.document_id

         AND    dtl.document_id = d.document_id

         AND    fad.entity_name = 'PO_HEADERS'