View: ECE_ATTACHMENT_V

Product:	EC - e-Commerce Gateway
Description:	/*#* This view extracts attachment data* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* The attachment view is used for header, line, shipment, distribution, item and master item
Implementation/DBA Data:	APPS.ECE_ATTACHMENT_V

View Text

SELECT FDD.DOCUMENT_ID DOCUMENT_ID
, FAD.ENTITY_NAME ENTITY_NAME
, FDC.NAME CATEGORY_NAME
, FAD.PK1_VALUE PK1_VALUE
, FAD.PK2_VALUE PK2_VALUE
, FAD.PK3_VALUE PK3_VALUE
, FAD.PK4_VALUE PK4_VALUE
, FAD.PK5_VALUE PK5_VALUE
, FDD.USAGE_TYPE USAGE_TYPE
, FDT.DESCRIPTION DESCRIPTION
, FDD.DATATYPE_ID DATATYPE_ID
, FDS.SHORT_TEXT SHORT_TEXT
, FDL.LONG_TEXT LONG_TEXT
, FDT.LANGUAGE LANGUAGE
, FDT.DOC_ATTRIBUTE_CATEGORY DOC_ATTRIBUTE_CATEGORY
, FDT.DOC_ATTRIBUTE1 DOC_ATTRIBUTE1
, FDT.DOC_ATTRIBUTE2 DOC_ATTRIBUTE2
, FDT.DOC_ATTRIBUTE3 DOC_ATTRIBUTE3
, FDT.DOC_ATTRIBUTE4 DOC_ATTRIBUTE4
, FDT.DOC_ATTRIBUTE5 DOC_ATTRIBUTE5
, FDT.DOC_ATTRIBUTE6 DOC_ATTRIBUTE6
, FDT.DOC_ATTRIBUTE7 DOC_ATTRIBUTE7
, FDT.DOC_ATTRIBUTE8 DOC_ATTRIBUTE8
, FDT.DOC_ATTRIBUTE9 DOC_ATTRIBUTE9
, FDT.DOC_ATTRIBUTE10 DOC_ATTRIBUTE10
, FDT.DOC_ATTRIBUTE11 DOC_ATTRIBUTE11
, FDT.DOC_ATTRIBUTE12 DOC_ATTRIBUTE12
, FDT.DOC_ATTRIBUTE13 DOC_ATTRIBUTE13
, FDT.DOC_ATTRIBUTE14 DOC_ATTRIBUTE14
, FDT.DOC_ATTRIBUTE15 DOC_ATTRIBUTE15
, FAD.SEQ_NUM ATT_SEQ_NUM
, FAD.ATTACHED_DOCUMENT_ID ATTACHED_DOCUMENT_ID
FROM FND_DOCUMENTS_LONG_TEXT FDL
, FND_DOCUMENTS_SHORT_TEXT FDS
, FND_DOCUMENT_CATEGORIES_TL FDC
, FND_ATTACHED_DOCUMENTS FAD
, FND_DOCUMENTS_TL FDT
, FND_DOCUMENTS FDD
WHERE FDT.MEDIA_ID = FDS.MEDIA_ID
AND FDD.DATATYPE_ID = 1
AND FDT.LANGUAGE = USERENV('LANG')
AND FDC.LANGUAGE = USERENV('LANG')
AND FDD.CATEGORY_ID = FDC.CATEGORY_ID
AND FDD.DOCUMENT_ID = FAD.DOCUMENT_ID
AND FDD.DOCUMENT_ID = FDT.DOCUMENT_ID
AND FDL.MEDIA_ID(+) = FDS.MEDIA_ID
AND FDL.MEDIA_ID(+) = -9999 UNION ALL SELECT FDD.DOCUMENT_ID DOCUMENT_ID
, FAD.ENTITY_NAME ENTITY_NAME
, FDC.NAME CATEGORY_NAME
, FAD.PK1_VALUE PK1_VALUE
, FAD.PK2_VALUE PK2_VALUE
, FAD.PK3_VALUE PK3_VALUE
, FAD.PK4_VALUE PK4_VALUE
, FAD.PK5_VALUE PK5_VALUE
, FDD.USAGE_TYPE USAGE_TYPE
, FDT.DESCRIPTION DESCRIPTION
, FDD.DATATYPE_ID DATATYPE_ID
, NULL SHORT_TEXT
, FDL.LONG_TEXT LONG_TEXT
, FDT.LANGUAGE LANGUAGE
, FDT.DOC_ATTRIBUTE_CATEGORY DOC_ATTRIBUTE_CATEGORY
, FDT.DOC_ATTRIBUTE1 DOC_ATTRIBUTE1
, FDT.DOC_ATTRIBUTE2 DOC_ATTRIBUTE2
, FDT.DOC_ATTRIBUTE3 DOC_ATTRIBUTE3
, FDT.DOC_ATTRIBUTE4 DOC_ATTRIBUTE4
, FDT.DOC_ATTRIBUTE5 DOC_ATTRIBUTE5
, FDT.DOC_ATTRIBUTE6 DOC_ATTRIBUTE6
, FDT.DOC_ATTRIBUTE7 DOC_ATTRIBUTE7
, FDT.DOC_ATTRIBUTE8 DOC_ATTRIBUTE8
, FDT.DOC_ATTRIBUTE9 DOC_ATTRIBUTE9
, FDT.DOC_ATTRIBUTE10 DOC_ATTRIBUTE10
, FDT.DOC_ATTRIBUTE11 DOC_ATTRIBUTE11
, FDT.DOC_ATTRIBUTE12 DOC_ATTRIBUTE12
, FDT.DOC_ATTRIBUTE13 DOC_ATTRIBUTE13
, FDT.DOC_ATTRIBUTE14 DOC_ATTRIBUTE14
, FDT.DOC_ATTRIBUTE15 DOC_ATTRIBUTE15
, FAD.SEQ_NUM ATT_SEQ_NUM
, FAD.ATTACHED_DOCUMENT_ID ATTACHED_DOCUMENT_ID
FROM FND_DOCUMENTS_LONG_TEXT FDL
, FND_DOCUMENT_CATEGORIES_TL FDC
, FND_ATTACHED_DOCUMENTS FAD
, FND_DOCUMENTS_TL FDT
, FND_DOCUMENTS FDD
WHERE FDT.MEDIA_ID = FDL.MEDIA_ID
AND FDD.DATATYPE_ID = 2
AND FDT.LANGUAGE = USERENV('LANG')
AND FDC.LANGUAGE = USERENV('LANG')
AND FDD.CATEGORY_ID = FDC.CATEGORY_ID
AND FDD.DOCUMENT_ID = FAD.DOCUMENT_ID
AND FDD.DOCUMENT_ID = FDT.DOCUMENT_ID

Columns