View: WIP_OPERATION_INSTRUCTIONS_V

Product:	WIP - Work in Process
Description:	Instructions attached to operations
Implementation/DBA Data:	APPS.WIP_OPERATION_INSTRUCTIONS_V

View Text

SELECT TO_NUMBER(DECODE(FAD.ENTITY_NAME
, 'WIP_REPETITIVE_OPERATIONS'
, FAD.PK1_VALUE
, 'WIP_DISCRETE_OPERATIONS'
, FAD.PK1_VALUE
, NULL)) WIP_ENTITY_ID
, TO_NUMBER(DECODE(FAD.ENTITY_NAME
, 'WIP_REPETITIVE_OPERATIONS'
, FAD.PK2_VALUE
, 'WIP_DISCRETE_OPERATIONS'
, FAD.PK2_VALUE
, NULL)) OPERATION_SEQ_NUM
, D.DESCRIPTION OPERATION_DESCRIPTION_CODE
, TO_NUMBER(DECODE(FAD.ENTITY_NAME
, 'WIP_REPETITIVE_OPERATIONS'
, FAD.PK3_VALUE
, 'WIP_DISCRETE_OPERATIONS'
, FAD.PK3_VALUE
, NULL)) ORGANIZATION_ID
, TO_NUMBER ( DECODE ( FAD.ENTITY_NAME
, 'WIP_REPETITIVE_OPERATIONS'
, FAD.PK4_VALUE
, 'WIP_DISCRETE_OPERATIONS'
, FAD.PK1_VALUE
, NULL) ) REPETITIVE_SCHEDULE_ID
, FAD.LAST_UPDATE_DATE
, FAD.LAST_UPDATED_BY
, FAD.CREATION_DATE
, FAD.CREATED_BY
, FAD.LAST_UPDATE_LOGIN
, FAD.REQUEST_ID
, FAD.PROGRAM_APPLICATION_ID
, FAD.PROGRAM_ID
, FAD.PROGRAM_UPDATE_DATE
, 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
, FAD.DOCUMENT_ID
FROM FND_ATTACHED_DOCUMENTS FAD
, FND_DOCUMENTS_VL D
, FND_DOCUMENT_CATEGORIES_VL C
WHERE FAD.ENTITY_NAME IN ('WIP_DISCRETE_OPERATIONS'
, 'WIP_REPETITIVE_OPERATIONS')
AND D.DOCUMENT_ID = FAD.DOCUMENT_ID
AND C.CATEGORY_ID = D.CATEGORY_ID
AND C.NAME = 'OPERATION_ATTACHMENTS'

Columns