VIEW: APPS.ENG_REVISED_OPERATIONS_V

Source

View Text - Preformatted

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(+) )

View Text - HTML Formatted

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(+) )