View: PO_ECX_ATTACHMENTS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_ECX_ATTACHMENTS_V

View Text

SELECT DT.MEDIA_ID MEDIA_ID
, DAT.DATATYPE_ID DATATYPE_ID
, DAT.NAME ATTACHED_DOCUMENT_TYPE
, FAD.PK1_VALUE ATTACHMENT_PK1
, FAD.ENTITY_NAME ATTACHMENT_ENTITY_NAME
FROM FND_DOCUMENT_DATATYPES DAT
, FND_DOCUMENTS D
, FND_DOCUMENT_CATEGORIES_TL DCT
, FND_DOCUMENTS_TL 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.LANGUAGE = USERENV('LANG')
AND DT.MEDIA_ID IS NOT NULL

Columns