
SELECT fde.table_name,
fde.data_object_code,
fdet.user_entity_name,
fdet.user_entity_prompt,
fat.application_name
FROM fnd_document_entities fde,
fnd_document_entities_tl fdet,
fnd_application_tl fat
WHERE fde.data_object_code = fdet.data_object_code
AND fdet.language = 'ZHS'
AND fde.application_id = fat.application_id
AND fat.language = 'ZHS'
AND fde.table_name LIKE 'PO_HEADERS_ALL%' SELECT * FROM fnd_attached_documents;
SELECT * FROM fnd_documents ;
SELECT * FROM fnd_documents_tl; SELECT ad.entity_name, ad.seq_num Seq, ad.pk1_value, dtl.file_name,d.MEDIA_ID
FROM fnd_documents d,
fnd_attached_documents ad,
fnd_documents_vl dtl,
po_headers_all h
WHERE d.document_id = ad.document_id
AND ad.entity_name = 'PO_HEAD'
AND ad.pk1_value = to_char(h.po_header_id)
--AND h.segment1 = '&po_number'
AND d.document_id = dtl.document_id; select * from fnd_lobs f where f.FILE_ID = 391907