Oracle SQL Query to get the Contract Attachments/Documents Details in Oracle fusion.

Here is the SQL Query to get the Contract Attachments/Documents details in Oracle fusion. This query can be modified accordingly as per the requirements. 

These are the tables, refer here in this post. Oracle Tables for the Contract Attachment Documents

SELECT oha.contract_number,

       oha.cognomen,

       fad.document_id,

       fdv.file_name

  FROM fnd_attached_documents fad,

       fnd_documents_vl fdv,

       okc_k_headers_vl oha

 WHERE fad.entity_name = 'OKC_SUPPORTING_DOCS'

   AND fad.document_id = fdv.document_id

   AND fad.pk1_value = oha.id

  ORDER BY oha.contract_number