VIEW: APPS.WIP_ENTITY_COMMENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'