VIEW: APPS.ECE_ATTACHMENT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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