EBS Attachements表结构

 

SELECT * FROM fnd_attached_documents;--系列的表保存我们在开发员职责里面的附件定义
SELECT * FROM fnd_documents;--系列的表保存最终用户的具体的附件业务数据
SELECT * FROM fnd_lobs;--file类型的附件存储在fnd_lobs表中
--fnd_documents_tl.media_id可以关联到fnd_lobs.file_id、fnd_documents_long_text.media_id、fnd_documents_shot_text.media_id取得相应的附件内容

--应用开发员配置
SELECT * FROM fnd_document_entities t where t.table_name='CUX_INV_WH_MANAGER_HEADER'; --文档实体
SELECT * FROM fnd_document_categories;--单据类别
SELECT * FROM fnd_attachment_functions t  WHERE t.function_name = 'CUXWHMANAGER'  ORDER BY t.creation_date desc;--附件功能
SELECT * FROM fnd_attachment_blk_entities t WHERE t.data_object_code='CUX_INV_WH_MANAGER_HEADER' ORDER BY t.creation_date DESC;--附件功能-块
SELECT * FROM fnd_attachment_blocks t  WHERE t.block_name='MANAGER_HEADER';--附件和功能的关系
SELECT * FROM fnd_doc_category_usages t WHERE t.attachment_function_id=1004818;

--附件应用相关的表
SELECT * FROM fnd_attached_documents;--实体名称
SELECT * FROM fnd_documents;--文档
SELECT * FROM fnd_lobs t ORDER BY t.file_name;--大对象
SELECT *
  FROM fnd_attached_documents t
 WHERE t.creation_date LIKE TO_DATE('2011-05-25', 'YYYY-MM-DD')
   AND t.entity_name = 'CUX_INV_WH_MANAGER_HEADER'; --附件
SELECT *
  FROM fnd_documents fd
 WHERE fd.document_id IN (117961, 117960, 117959, 117958, 117957);
SELECT * FROM fnd_lobs t WHERE t.file_id IN (496821, 496827, 496829);--文件格式。
SELECT * FROM fnd_documents_long_text t WHERE t.media_id = 1001; --长文本
SELECT * FROM fnd_documents_short_text t WHERE t.media_id = 2; --短文本