FND_ATTACHMENT Details Oracle Apps

SELECT   fndattdoc.pk1_value
        ,st.short_text
        ,fdlt.long_text
        ,pk1_value hdr_attach_pk
        ,fnddoc.datatype_name hdr_attach_dtype
        ,fndattfn.function_name
        ,fndattdoc.entity_name
    FROM fnd_attachment_functions fndattfn
        ,fnd_doc_category_usages fndcatusg
        ,fnd_documents_vl fnddoc
        ,fnd_attached_documents fndattdoc
        ,fnd_documents_short_text st
        ,fnd_documents_long_text fdlt
   WHERE fndattfn.attachment_function_id = fndcatusg.attachment_function_id
     AND fndcatusg.category_id = fnddoc.category_id
     AND fnddoc.document_id = fndattdoc.document_id
     AND fndattfn.function_name =<Func. Name>
     AND fndattdoc.entity_name =<Entity Name>
     AND fnddoc.category_description = <Category Name>
     AND fnddoc.media_id = st.media_id
     AND fnddoc.media_id = fdlt.media_id
ORDER BY fndattdoc.seq_num