View: BOM_OPERATION_SEQUENCES_V

Product:	BOM - Bills of Material
Description:	Operations
Implementation/DBA Data:	APPS.BOM_OPERATION_SEQUENCES_V

View Text

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'

Columns