Query to fetch Supplier Attachments

 Hi

Following query can be used to see Supplier Attachment related details in Fusion.

select psv.SEGMENT1 Suppliernumber,

          fdv.FILE_NAME, 

      fdv.TITLE,

  fdv.URL

from 

fnd_attached_documents    fad,

fnd_documents_vl               fdv,

POZ_SUPPLIERS_V         psv

WHERE  1=1

AND    fad.document_id = fdv.document_id 

AND    fad.entity_name = 'POZ_SUPPLIERS'

AND    fad.pk1_value                             = psv.vendor_id