Oracle EBS 附件功能

 

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