VIEW: APPS.WIP_OPERATION_INSTRUCTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'