View: WIP_ENTITY_COMMENTS_V

Product:	WIP - Work in Process
Description:	Attachments to WIP entities
Implementation/DBA Data:	APPS.WIP_ENTITY_COMMENTS_V

View Text

SELECT TO_NUMBER(FAD.PK1_VALUE) WIP_ENTITY_ID
, TO_NUMBER ( DECODE ( FAD.ENTITY_NAME
, 'WIP_REPETITIVE_SCHEDULES'
, FAD.PK3_VALUE
, 'WIP_DISCRETE_JOBS'
, FAD.PK2_VALUE ) ) ORGANIZATION_ID
, D.DESCRIPTION COMMENT_CODE
, TO_NUMBER ( DECODE ( FAD.ENTITY_NAME
, 'WIP_REPETITIVE_SCHEDULES'
, FAD.PK2_VALUE
, /* WIP_DISCRETE_JOBS ==> */ NULL ) ) REPETITIVE_SCHEDULE_ID
, FAD.LAST_UPDATE_DATE
, FAD.LAST_UPDATED_BY
, FAD.CREATION_DATE
, FAD.CREATED_BY
, FAD.LAST_UPDATE_LOGIN
, FAD.ATTRIBUTE_CATEGORY
, FAD.ATTRIBUTE1
, FAD.ATTRIBUTE2
, FAD.ATTRIBUTE3
, FAD.ATTRIBUTE4
, FAD.ATTRIBUTE5
, FAD.ATTRIBUTE6
, FAD.ATTRIBUTE7
, FAD.ATTRIBUTE8
, FAD.ATTRIBUTE9
, FAD.ATTRIBUTE10
, FAD.ATTRIBUTE11
, FAD.ATTRIBUTE12
, FAD.ATTRIBUTE13
, FAD.ATTRIBUTE14
, FAD.ATTRIBUTE15
, NULL AS APP_SOURCE_VERSION
FROM FND_ATTACHED_DOCUMENTS FAD
, FND_DOCUMENTS_VL D
, FND_DOCUMENT_CATEGORIES_VL C
WHERE FAD.ENTITY_NAME IN ('WIP_DISCRETE_JOBS'
, 'WIP_REPETITIVE_SCHEDULES')
AND D.DOCUMENT_ID = FAD.DOCUMENT_ID
AND C.CATEGORY_ID = D.CATEGORY_ID
AND C.NAME = 'WIP_ENTITY_ATTACHMENTS'

Columns