View: ENG_REVISED_OPERATIONS_V

Product:	ENG - Engineering
Description:	Pending and implemented revised operations
Implementation/DBA Data:	APPS.ENG_REVISED_OPERATIONS_V

View Text

SELECT A.ROWID ROW_ID
, A.OPERATION_SEQUENCE_ID
, A.ROUTING_SEQUENCE_ID
, A.OPERATION_SEQ_NUM
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, BSO.OPERATION_CODE STANDARD_OPERATION_CODE
, A.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, A.DEPARTMENT_ID
, BD.LOCATION_ID
, A.OPERATION_LEAD_TIME_PERCENT
, A.MINIMUM_TRANSFER_QUANTITY
, A.COUNT_POINT_TYPE
, A.OPERATION_DESCRIPTION
, A.EFFECTIVITY_DATE
, A.DISABLE_DATE
, A.BACKFLUSH_FLAG
, A.OPTION_DEPENDENT_FLAG
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, DECODE(A.COUNT_POINT_TYPE
, 1
, 1
, 2) COUNT_POINT_FLAG
, DECODE(A.COUNT_POINT_TYPE
, 3
, 2
, 1) AUTOCHARGE_FLAG
, NVL(A.OPERATION_TYPE
, 1)
, NVL(A.REFERENCE_FLAG
, 2)
, A.PROCESS_OP_SEQ_ID
, A.OPERATION_SEQ_NUM
, BSO.OPERATION_CODE
, A.LINE_OP_SEQ_ID
, A.OPERATION_SEQ_NUM
, BSO.OPERATION_CODE
, A.YIELD
, A.CUMULATIVE_YIELD
, A.REVERSE_CUMULATIVE_YIELD
, A.LABOR_TIME_CALC
, A.MACHINE_TIME_CALC
, A.TOTAL_TIME_CALC
, A.LABOR_TIME_USER
, A.MACHINE_TIME_USER
, A.TOTAL_TIME_USER
, A.NET_PLANNING_PERCENT
, A.X_COORDINATE
, A.Y_COORDINATE
, A.INCLUDE_IN_ROLLUP
, A.OPERATION_YIELD_ENABLED
, A.CHANGE_NOTICE
, A.IMPLEMENTATION_DATE
, A.OLD_OPERATION_SEQUENCE_ID
, A.ACD_TYPE
, A.REVISED_ITEM_SEQUENCE_ID
, A.CANCELLATION_DATE
, A.CANCEL_COMMENTS
, A.ORIGINAL_SYSTEM_REFERENCE
, NVL(A.ECO_FOR_PRODUCTION
, 2)
FROM BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
, BOM_OPERATIONAL_ROUTINGS BOR
, ENG_REVISED_ITEMS ERI
, ENG_REVISED_OPERATIONS A
WHERE A.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND A.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
AND A.IMPLEMENTATION_DATE IS NOT NULL
AND A.CHANGE_NOTICE IS NOT NULL
AND A.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND A.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID(+) UNION ( SELECT B.ROWID
, B.OPERATION_SEQUENCE_ID
, B.ROUTING_SEQUENCE_ID
, B.OPERATION_SEQ_NUM
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, BSO.OPERATION_CODE STANDARD_OPERATION_CODE
, B.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, B.DEPARTMENT_ID
, BD.LOCATION_ID
, B.OPERATION_LEAD_TIME_PERCENT
, B.MINIMUM_TRANSFER_QUANTITY
, B.COUNT_POINT_TYPE
, B.OPERATION_DESCRIPTION
, B.EFFECTIVITY_DATE
, B.DISABLE_DATE
, B.BACKFLUSH_FLAG
, B.OPTION_DEPENDENT_FLAG
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, DECODE(B.COUNT_POINT_TYPE
, 1
, 1
, 2) COUNT_POINT_FLAG
, DECODE(B.COUNT_POINT_TYPE
, 3
, 2
, 1) AUTOCHARGE_FLAG
, NVL(B.OPERATION_TYPE
, 1)
, NVL(B.REFERENCE_FLAG
, 2)
, B.PROCESS_OP_SEQ_ID
, BOS1.OPERATION_SEQ_NUM
, BSO1.OPERATION_CODE
, B.LINE_OP_SEQ_ID
, BOS2.OPERATION_SEQ_NUM
, BSO2.OPERATION_CODE
, B.YIELD
, B.CUMULATIVE_YIELD
, B.REVERSE_CUMULATIVE_YIELD
, B.LABOR_TIME_CALC
, B.MACHINE_TIME_CALC
, B.TOTAL_TIME_CALC
, B.LABOR_TIME_USER
, B.MACHINE_TIME_USER
, B.TOTAL_TIME_USER
, B.NET_PLANNING_PERCENT
, B.X_COORDINATE
, B.Y_COORDINATE
, B.INCLUDE_IN_ROLLUP
, B.OPERATION_YIELD_ENABLED
, B.CHANGE_NOTICE
, B.IMPLEMENTATION_DATE
, B.OLD_OPERATION_SEQUENCE_ID
, B.ACD_TYPE
, B.REVISED_ITEM_SEQUENCE_ID
, TO_DATE(NULL) CANCELLATION_DATE
, NULL CANCEL_COMMENTS
, B.ORIGINAL_SYSTEM_REFERENCE
, NVL(B.ECO_FOR_PRODUCTION
, 2)
FROM BOM_OPERATION_SEQUENCES BOS1
, BOM_OPERATION_SEQUENCES BOS2
, BOM_OPERATION_SEQUENCES B
, BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO1
, BOM_STANDARD_OPERATIONS BSO2
, BOM_STANDARD_OPERATIONS BSO
WHERE B.IMPLEMENTATION_DATE IS NULL
AND B.CHANGE_NOTICE IS NOT NULL
AND B.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND B.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID(+)
AND B.PROCESS_OP_SEQ_ID = BOS1.OPERATION_SEQUENCE_ID(+)
AND BOS1.STANDARD_OPERATION_ID = BSO1.STANDARD_OPERATION_ID(+)
AND B.LINE_OP_SEQ_ID = BOS2.OPERATION_SEQUENCE_ID(+)
AND BOS2.STANDARD_OPERATION_ID = BSO2.STANDARD_OPERATION_ID(+) )

Columns