VIEW: APPS.BOM_OPERATION_SEQUENCES_V

Source

View Text - Preformatted

SELECT BOS.ROWID ROW_ID , BOS.OPERATION_SEQUENCE_ID , BOS.ROUTING_SEQUENCE_ID , BOS.OPERATION_SEQ_NUM , BOS.LAST_UPDATE_DATE , BOS.LAST_UPDATED_BY , BOS.CREATION_DATE , BOS.CREATED_BY , BOS.LAST_UPDATE_LOGIN , BSO.OPERATION_CODE STANDARD_OPERATION_CODE , BOS.STANDARD_OPERATION_ID , BD.DEPARTMENT_CODE , BOS.DEPARTMENT_ID , BD.LOCATION_ID , BOS.OPERATION_LEAD_TIME_PERCENT , BOS.MINIMUM_TRANSFER_QUANTITY , BOS.COUNT_POINT_TYPE , BOS.OPERATION_DESCRIPTION , BOS.EFFECTIVITY_DATE , BOS.DISABLE_DATE , BOS.BACKFLUSH_FLAG , BOS.OPTION_DEPENDENT_FLAG , BOS.ATTRIBUTE_CATEGORY , BOS.ATTRIBUTE1 , BOS.ATTRIBUTE2 , BOS.ATTRIBUTE3 , BOS.ATTRIBUTE4 , BOS.ATTRIBUTE5 , BOS.ATTRIBUTE6 , BOS.ATTRIBUTE7 , BOS.ATTRIBUTE8 , BOS.ATTRIBUTE9 , BOS.ATTRIBUTE10 , BOS.ATTRIBUTE11 , BOS.ATTRIBUTE12 , BOS.ATTRIBUTE13 , BOS.ATTRIBUTE14 , BOS.ATTRIBUTE15 , BOS.REQUEST_ID , BOS.PROGRAM_APPLICATION_ID , BOS.PROGRAM_ID , BOS.PROGRAM_UPDATE_DATE , decode(bos.count_point_type, 1, 1, 2) count_point_flag , decode(bos.count_point_type, 3, 2, 1) autocharge_flag , NVL(bos.operation_type, 1) , NVL(bos.reference_flag, 2) , bos.process_op_Seq_id ,bos1.operation_seq_num , bso1.operation_code , bos.line_op_seq_id ,bos2.operation_seq_num , bso2.operation_code , bos.yield , bos.cumulative_yield , bos.reverse_cumulative_yield , bos.labor_time_calc , bos.machine_time_calc , bos.total_time_calc , bos.labor_time_user , bos.machine_time_user , bos.total_time_user , bos.net_planning_percent , bos.include_in_rollup , bos.operation_yield_enabled , BOS.CHANGE_NOTICE , BOS.IMPLEMENTATION_DATE , DECODE(BOS.IMPLEMENTATION_DATE,NULL,2,1) IMPL_CB , BOS.OLD_OPERATION_SEQUENCE_ID , BOS.ACD_TYPE , BOS.REVISED_ITEM_SEQUENCE_ID , BOS.ORIGINAL_SYSTEM_REFERENCE , NVL(BOS.ECO_FOR_PRODUCTION,2) , BOS.SHUTDOWN_TYPE , ML.MEANING SHUTDOWN_TYPE_VALUE , BOS.MACHINE_PROCESS_EFFICIENCY , BOS.LABOR_PROCESS_EFFICIENCY , BOS.TOTAL_PROCESS_EFFICIENCY , BOS.CRITICAL_TO_QUALITY , BOS.VALUE_ADDED , BOS.LONG_DESCRIPTION , BOS.CONFIG_ROUTING_ID , BOS.MODEL_OP_SEQ_ID ,BOS.LOWEST_ACCEPTABLE_YIELD , BOS.USE_ORG_SETTINGS , BOS.QUEUE_MANDATORY_FLAG , BOS.RUN_MANDATORY_FLAG , BOS.TO_MOVE_MANDATORY_FLAG , BOS.SHOW_NEXT_OP_BY_DEFAULT , BOS.SHOW_SCRAP_CODE , BOS.SHOW_LOT_ATTRIB , BOS.TRACK_MULTIPLE_RES_USAGE_DATES ,nvl(BOS.CHECK_SKILL,2) CHECK_SKILL FROM bom_operation_sequences bos1 , bom_operation_sequences bos2 , BOM_OPERATION_SEQUENCES BOS , BOM_DEPARTMENTS BD , bom_standard_operations bso1 , bom_standard_operations bso2 , BOM_STANDARD_OPERATIONS BSO , MFG_LOOKUPS ML WHERE BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID AND BOS.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) AND bos.process_op_seq_id = bos1.operation_sequence_id (+) AND bos1.standard_operation_id = bso1.standard_operation_id (+) AND bos.line_op_seq_id = bos2.operation_sequence_id (+) AND bos2.standard_operation_id = bso2.standard_operation_id (+) AND NVL(BOS.ECO_FOR_PRODUCTION,2) = 2 AND ML.LOOKUP_CODE(+) = TO_NUMBER(BOS.SHUTDOWN_TYPE) AND ML.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'

View Text - HTML Formatted

SELECT BOS.ROWID ROW_ID
, BOS.OPERATION_SEQUENCE_ID
, BOS.ROUTING_SEQUENCE_ID
, BOS.OPERATION_SEQ_NUM
, BOS.LAST_UPDATE_DATE
, BOS.LAST_UPDATED_BY
, BOS.CREATION_DATE
, BOS.CREATED_BY
, BOS.LAST_UPDATE_LOGIN
, BSO.OPERATION_CODE STANDARD_OPERATION_CODE
, BOS.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, BOS.DEPARTMENT_ID
, BD.LOCATION_ID
, BOS.OPERATION_LEAD_TIME_PERCENT
, BOS.MINIMUM_TRANSFER_QUANTITY
, BOS.COUNT_POINT_TYPE
, BOS.OPERATION_DESCRIPTION
, BOS.EFFECTIVITY_DATE
, BOS.DISABLE_DATE
, BOS.BACKFLUSH_FLAG
, BOS.OPTION_DEPENDENT_FLAG
, BOS.ATTRIBUTE_CATEGORY
, BOS.ATTRIBUTE1
, BOS.ATTRIBUTE2
, BOS.ATTRIBUTE3
, BOS.ATTRIBUTE4
, BOS.ATTRIBUTE5
, BOS.ATTRIBUTE6
, BOS.ATTRIBUTE7
, BOS.ATTRIBUTE8
, BOS.ATTRIBUTE9
, BOS.ATTRIBUTE10
, BOS.ATTRIBUTE11
, BOS.ATTRIBUTE12
, BOS.ATTRIBUTE13
, BOS.ATTRIBUTE14
, BOS.ATTRIBUTE15
, BOS.REQUEST_ID
, BOS.PROGRAM_APPLICATION_ID
, BOS.PROGRAM_ID
, BOS.PROGRAM_UPDATE_DATE
, DECODE(BOS.COUNT_POINT_TYPE
, 1
, 1
, 2) COUNT_POINT_FLAG
, DECODE(BOS.COUNT_POINT_TYPE
, 3
, 2
, 1) AUTOCHARGE_FLAG
, NVL(BOS.OPERATION_TYPE
, 1)
, NVL(BOS.REFERENCE_FLAG
, 2)
, BOS.PROCESS_OP_SEQ_ID
, BOS1.OPERATION_SEQ_NUM
, BSO1.OPERATION_CODE
, BOS.LINE_OP_SEQ_ID
, BOS2.OPERATION_SEQ_NUM
, BSO2.OPERATION_CODE
, BOS.YIELD
, BOS.CUMULATIVE_YIELD
, BOS.REVERSE_CUMULATIVE_YIELD
, BOS.LABOR_TIME_CALC
, BOS.MACHINE_TIME_CALC
, BOS.TOTAL_TIME_CALC
, BOS.LABOR_TIME_USER
, BOS.MACHINE_TIME_USER
, BOS.TOTAL_TIME_USER
, BOS.NET_PLANNING_PERCENT
, BOS.INCLUDE_IN_ROLLUP
, BOS.OPERATION_YIELD_ENABLED
, BOS.CHANGE_NOTICE
, BOS.IMPLEMENTATION_DATE
, DECODE(BOS.IMPLEMENTATION_DATE
, NULL
, 2
, 1) IMPL_CB
, BOS.OLD_OPERATION_SEQUENCE_ID
, BOS.ACD_TYPE
, BOS.REVISED_ITEM_SEQUENCE_ID
, BOS.ORIGINAL_SYSTEM_REFERENCE
, NVL(BOS.ECO_FOR_PRODUCTION
, 2)
, BOS.SHUTDOWN_TYPE
, ML.MEANING SHUTDOWN_TYPE_VALUE
, BOS.MACHINE_PROCESS_EFFICIENCY
, BOS.LABOR_PROCESS_EFFICIENCY
, BOS.TOTAL_PROCESS_EFFICIENCY
, BOS.CRITICAL_TO_QUALITY
, BOS.VALUE_ADDED
, BOS.LONG_DESCRIPTION
, BOS.CONFIG_ROUTING_ID
, BOS.MODEL_OP_SEQ_ID
, BOS.LOWEST_ACCEPTABLE_YIELD
, BOS.USE_ORG_SETTINGS
, BOS.QUEUE_MANDATORY_FLAG
, BOS.RUN_MANDATORY_FLAG
, BOS.TO_MOVE_MANDATORY_FLAG
, BOS.SHOW_NEXT_OP_BY_DEFAULT
, BOS.SHOW_SCRAP_CODE
, BOS.SHOW_LOT_ATTRIB
, BOS.TRACK_MULTIPLE_RES_USAGE_DATES
, NVL(BOS.CHECK_SKILL
, 2) CHECK_SKILL
FROM BOM_OPERATION_SEQUENCES BOS1
, BOM_OPERATION_SEQUENCES BOS2
, BOM_OPERATION_SEQUENCES BOS
, BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO1
, BOM_STANDARD_OPERATIONS BSO2
, BOM_STANDARD_OPERATIONS BSO
, MFG_LOOKUPS ML
WHERE BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND BOS.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND BOS.PROCESS_OP_SEQ_ID = BOS1.OPERATION_SEQUENCE_ID (+)
AND BOS1.STANDARD_OPERATION_ID = BSO1.STANDARD_OPERATION_ID (+)
AND BOS.LINE_OP_SEQ_ID = BOS2.OPERATION_SEQUENCE_ID (+)
AND BOS2.STANDARD_OPERATION_ID = BSO2.STANDARD_OPERATION_ID (+)
AND NVL(BOS.ECO_FOR_PRODUCTION
, 2) = 2
AND ML.LOOKUP_CODE(+) = TO_NUMBER(BOS.SHUTDOWN_TYPE)
AND ML.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'