VIEW: APPS.PO_ECX_ATTACHMENTS_V

Source

View Text - Preformatted

SELECT dt.media_id MEDIA_ID, dat.datatype_id DATATYPE_ID, dat.name ATTACHED_DOCUMENT_TYPE, fad.pk1_value ATTACHMENT_PK1, fad.pk2_value ATTACHMENT_PK2, fad.pk3_value ATTACHMENT_PK3, fad.pk4_value ATTACHMENT_PK4, fad.pk5_value ATTACHMENT_PK5, fad.entity_name ATTACHMENT_ENTITY_NAME, dt.document_id DOCUMENT_ID from FND_DOCUMENT_DATATYPES DAT, FND_DOCUMENTS D, FND_DOCUMENT_CATEGORIES_TL DCT, FND_DOCUMENTS_VL DT, fnd_attached_documents fad WHERE d.datatype_id = dat.datatype_id and d.category_id = dct.category_id and dct.name = 'Vendor' and DCT.LANGUAGE = USERENV('LANG') and d.document_id = fad.document_id and dat.language = userenv('LANG') and dt.document_id = d.document_id and dt.media_id is not null

View Text - HTML Formatted

SELECT DT.MEDIA_ID MEDIA_ID
, DAT.DATATYPE_ID DATATYPE_ID
, DAT.NAME ATTACHED_DOCUMENT_TYPE
, FAD.PK1_VALUE ATTACHMENT_PK1
, FAD.PK2_VALUE ATTACHMENT_PK2
, FAD.PK3_VALUE ATTACHMENT_PK3
, FAD.PK4_VALUE ATTACHMENT_PK4
, FAD.PK5_VALUE ATTACHMENT_PK5
, FAD.ENTITY_NAME ATTACHMENT_ENTITY_NAME
, DT.DOCUMENT_ID DOCUMENT_ID
FROM FND_DOCUMENT_DATATYPES DAT
, FND_DOCUMENTS D
, FND_DOCUMENT_CATEGORIES_TL DCT
, FND_DOCUMENTS_VL DT
, FND_ATTACHED_DOCUMENTS FAD
WHERE D.DATATYPE_ID = DAT.DATATYPE_ID
AND D.CATEGORY_ID = DCT.CATEGORY_ID
AND DCT.NAME = 'VENDOR'
AND DCT.LANGUAGE = USERENV('LANG')
AND D.DOCUMENT_ID = FAD.DOCUMENT_ID
AND DAT.LANGUAGE = USERENV('LANG')
AND DT.DOCUMENT_ID = D.DOCUMENT_ID
AND DT.MEDIA_ID IS NOT NULL