查询Form的头行附件:
SELECT st.short_text order_short_text,
description order_attach_desc,
pk1_value order_hdr_attach_pk,
fnddoc.datatype_name order_hdr_attach_dtype
FROM
fnd_attachment_functions fndattfn,
fnd_doc_category_usages fndcatusg,
fnd_documents_vl fnddoc,
fnd_attached_documents fndattdoc,
fnd_documents_short_text st
WHERE fndattfn.attachment_function_id=fndcatusg.attachment_function_id and
fndcatusg.category_id=fnddoc.category_id and
fnddoc.document_id=fndattdoc.document_id and
fnddoc.media_id=st.media_id
fndattfn.function_name='WSHRDINV' and
fndattdoc.entity_name='OE_ORDER_HEADERS' and
and UPPER(datatype_name)='SHORT TEXT'