SQL Query to view attachments from backend EBS R12

 AP Invoice:

select  

d.file_name, 

file_data,

fnd.item_key item_key

from apps.fnd_attached_documents fad,

apps.ap_invoices_all aia,

apps.fnd_documents d,

 apps.fnd_lobs fl,

 apps.wf_notifications fnd

where 1=1

and aia.invoice_id = fad.pk1_value

and fad.entity_name = 'AP_INVOICES'

and fad.document_id = d.document_id 

AND d.media_id = fl.file_id

and aia.invoice_id = substr(fnd.item_key,1,8)

and message_type = 'APINVAPR' ;

SSHR:

SELECT fl.file_name file_name, file_data, hapi.item_key

  FROM apps.fnd_attached_documents      fad,

       apps.fnd_documents               fd,

       apps.fnd_lobs                    fl,

       apps.fnd_document_datatypes      fdd,

       apps.fnd_document_categories_tl  fdct,

       apps.hr_api_transactions hapi

 WHERE     fad.document_id = fd.document_id

       AND fd.media_id = fl.file_id

       AND fd.datatype_id = fdd.datatype_id

       AND fd.category_id = fdct.category_id

       AND fdd.user_name = 'File'

       AND fad.entity_name = 'PQH_SS_ATTACHMENT'

       AND fdct.language = 'US'

       AND pk1_value = hapi.TRANSACTION_ID

       AND item_type = 'HRSSA'

PO:

SELECT fl.file_name file_name, file_data, WF_ITEM_KEY item_key

  FROM apps.fnd_attached_documents      fad,

       apps.fnd_documents               fd,

       apps.fnd_lobs                    fl,

       apps.fnd_document_datatypes      fdd,

       apps.fnd_document_categories_tl  fdct,

       APPS.po_headers_all POH

 WHERE     fad.document_id = fd.document_id

       AND fd.media_id = fl.file_id

       AND fd.datatype_id = fdd.datatype_id

       AND fd.category_id = fdct.category_id

       AND fdd.user_name = 'File'

       AND fad.entity_name = 'PO_HEADERS'

       AND fdct.language = 'US'

       AND PK1_VALUE = PO_HEADER_ID

--       AND WF_ITEM_KEY = :item_key_p 

       AND WF_ITEM_TYPE = 'POAPPRV'