EBS存储附件信息

rule

附件三种形式

1.文件

2.url

3.文本



三种方式存储不一样

1.文件是存blob

2.url是存一个链接信息，读出来的时候，就是一个蓝色可点链接





fnd_attached_documents fad
,fnd_documents_tl fdt
,fnd_documents fd
,fnd_lobs fl   









附件中类型有五类：

1.Short Text， 2.Long Text，3.Image，4.OLE Object, 5.Web Page






--1. 查询 Long Text数据：
SELECT
FAD.SEQ_NUM "Seq Number",
FDAT.USER_NAME "Data Type",
FDCT.USER_NAME "Category User Name",
FAD.ATTACHED_DOCUMENT_ID "Attached Document Id",
FDET.USER_ENTITY_NAME "User Entity",
FD.DOCUMENT_ID "Document Id",
FAD.ENTITY_NAME "Entity Name",
FD.MEDIA_ID "Media Id",
FD.URL "Url",
FDT.TITLE "Title",
FDLT.LONG_TEXT "Attachment Text"
FROM
FND_DOCUMENT_DATATYPES FDAT,
FND_DOCUMENT_ENTITIES_TL FDET,
FND_DOCUMENTS_TL FDT,
FND_DOCUMENTS FD,
FND_DOCUMENT_CATEGORIES_TL FDCT,
FND_ATTACHED_DOCUMENTS   FAD,
FND_DOCUMENTS_LONG_TEXT FDLT
WHERE
FD.DOCUMENT_ID          = FAD.DOCUMENT_ID
AND FDT.DOCUMENT_ID     = FD.DOCUMENT_ID
AND FDCT.CATEGORY_ID    = FD.CATEGORY_ID
AND FD.DATATYPE_ID      = FDAT.DATATYPE_ID
AND FAD.ENTITY_NAME     = FDET.DATA_OBJECT_CODE
AND FDLT.MEDIA_ID       = FD.MEDIA_ID
AND FDAT.NAME           = 'LONG_TEXT'
--2. 查询Short Text ：
SELECT
FAD.SEQ_NUM "Seq Number",
FDAT.USER_NAME "Data Type",
FDCT.USER_NAME "Category User Name",
FAD.ATTACHED_DOCUMENT_ID "Attached Document Id",
FDET.USER_ENTITY_NAME "User Entity",
FD.DOCUMENT_ID "Document Id",
FAD.ENTITY_NAME "Entity Name",
FD.MEDIA_ID "Media Id",
FD.URL "Url",
FDT.TITLE "Title",
FDST.SHORT_TEXT "Attachment Text"
FROM
FND_DOCUMENT_DATATYPES FDAT,
FND_DOCUMENT_ENTITIES_TL FDET,
FND_DOCUMENTS_TL FDT,
FND_DOCUMENTS FD,
FND_DOCUMENT_CATEGORIES_TL FDCT,
FND_ATTACHED_DOCUMENTS   FAD,
FND_DOCUMENTS_SHORT_TEXT FDST
WHERE
FD.DOCUMENT_ID          = FAD.DOCUMENT_ID
AND FDT.DOCUMENT_ID     = FD.DOCUMENT_ID
AND FDCT.CATEGORY_ID    = FD.CATEGORY_ID
AND FD.DATATYPE_ID      = FDAT.DATATYPE_ID
AND FAD.ENTITY_NAME     = FDET.DATA_OBJECT_CODE
AND FDST.MEDIA_ID       = FD.MEDIA_ID
AND FDAT.NAME           = 'SHORT_TEXT'

(插入的时候有函数，提取的时候应该也有函数,能批量提取，就基本不是问题了,都有对应的API的,



API : FND_ATTACHED_DOCUMENTS_PKG)

涉及到表如下：

1. FND_DOCUMENTS

2. FND_ATTACHED_DOCUMENTS

3. FND_DOCUMENTS_TL

4. FND_DOCUMENT_DATATYPES.

5. FND_DOCUMENT_CATEGORIES

6. FND_DOCUMENTS_LONG_TEXT (Long text type attachment).

7. FND_DOCUMENTS_SHORT_TEXT (Short text type attachment).

8. FND_DOCUMENTS_LONG_RAW

9. FND_LOBS (File type attachments).