View: MSC_ROUTING_OPERATIONS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view shows all the operations in a routing
Implementation/DBA Data:	APPS.MSC_ROUTING_OPERATIONS_V

View Text

SELECT MRO.PLAN_ID
, MBC.ORGANIZATION_ID
, MRO.SR_INSTANCE_ID
, MSC_GET_NAME.ORG_CODE(MBC.ORGANIZATION_ID
, MBC.SR_INSTANCE_ID)
, MRO.OPERATION_SEQUENCE_ID
, MRO.ROUTING_SEQUENCE_ID
, MR.ALTERNATE_ROUTING_DESIGNATOR
, MOC.BILL_SEQUENCE_ID
, MSC_GET_NAME.ALTERNATE_BOM(MRO.PLAN_ID
, MRO.SR_INSTANCE_ID
, MOC.BILL_SEQUENCE_ID)
, MBC.INVENTORY_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(MBC.INVENTORY_ITEM_ID
, MBC.ORGANIZATION_ID
, MBC.PLAN_ID
, MBC.SR_INSTANCE_ID)
, MRO.OPERATION_SEQ_NUM
, MRO.OPERATION_DESCRIPTION
, MRO.EFFECTIVITY_DATE
, MRO.DISABLE_DATE
, MRO.FROM_UNIT_NUMBER
, MRO.TO_UNIT_NUMBER
, MRO.OPTION_DEPENDENT_FLAG
, MRO.OPERATION_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('BOM_OPERATION_TYPE'
, MRO.OPERATION_TYPE)
, MRO.MINIMUM_TRANSFER_QUANTITY
, MRO.YIELD
, MRO.DEPARTMENT_ID
, MRO.DEPARTMENT_CODE
, MRO.OPERATION_LEAD_TIME_PERCENT
, MRO.CUMULATIVE_YIELD
, MRO.REVERSE_CUMULATIVE_YIELD
, MRO.NET_PLANNING_PERCENT
, MRO.SETUP_DURATION
, MRO.TEAR_DOWN_DURATION
, MRO.UOM_CODE
, MRO.STANDARD_OPERATION_CODE
, MBC.USING_ASSEMBLY_ID
, MSC_GET_NAME.ITEM_NAME(MBC.USING_ASSEMBLY_ID
, MBC.ORGANIZATION_ID
, MBC.PLAN_ID
, MBC.SR_INSTANCE_ID)
, MR.LINE_ID
, MSC_GET_NAME.DEPARTMENT_CODE(1
, MR.LINE_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, DECODE(MRO.USE_IN_PLAN
, NULL
, NULL
, MFG.MEANING)
FROM MSC_BOM_COMPONENTS MBC
, MSC_ROUTINGS MR
, MSC_OPERATION_COMPONENTS MOC
, MSC_ROUTING_OPERATIONS MRO
, MFG_LOOKUPS MFG
WHERE MBC.BILL_SEQUENCE_ID = MOC.BILL_SEQUENCE_ID
AND MBC.PLAN_ID = MOC.PLAN_ID
AND MBC.SR_INSTANCE_ID = MOC.SR_INSTANCE_ID
AND MBC.ORGANIZATION_ID = MOC.ORGANIZATION_ID
AND MBC.COMPONENT_SEQUENCE_ID = MOC.COMPONENT_SEQUENCE_ID
AND MRO.ROUTING_SEQUENCE_ID = MOC.ROUTING_SEQUENCE_ID
AND MRO.SR_INSTANCE_ID = MOC.SR_INSTANCE_ID
AND MRO.PLAN_ID = MOC.PLAN_ID
AND MRO.OPERATION_SEQUENCE_ID = MOC.OPERATION_SEQUENCE_ID
AND MR.PLAN_ID = MRO.PLAN_ID
AND MR.ROUTING_SEQUENCE_ID = MRO.ROUTING_SEQUENCE_ID
AND MR.SR_INSTANCE_ID = MRO.SR_INSTANCE_ID
AND NVL(MRO.USE_IN_PLAN
, 1) = MFG.LOOKUP_CODE
AND MFG.LOOKUP_TYPE = 'SYS_YES_NO' UNION ALL SELECT MRO.PLAN_ID
, MR.ORGANIZATION_ID
, MRO.SR_INSTANCE_ID
, MSC_GET_NAME.ORG_CODE(MR.ORGANIZATION_ID
, MRO.SR_INSTANCE_ID)
, MRO.OPERATION_SEQUENCE_ID
, MRO.ROUTING_SEQUENCE_ID
, MR.ALTERNATE_ROUTING_DESIGNATOR
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, MRO.OPERATION_SEQ_NUM
, MRO.OPERATION_DESCRIPTION
, MRO.EFFECTIVITY_DATE
, MRO.DISABLE_DATE
, MRO.FROM_UNIT_NUMBER
, MRO.TO_UNIT_NUMBER
, MRO.OPTION_DEPENDENT_FLAG
, MRO.OPERATION_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('BOM_OPERATION_TYPE'
, MRO.OPERATION_TYPE)
, MRO.MINIMUM_TRANSFER_QUANTITY
, MRO.YIELD
, MRO.DEPARTMENT_ID
, MRO.DEPARTMENT_CODE
, MRO.OPERATION_LEAD_TIME_PERCENT
, MRO.CUMULATIVE_YIELD
, MRO.REVERSE_CUMULATIVE_YIELD
, MRO.NET_PLANNING_PERCENT
, MRO.SETUP_DURATION
, MRO.TEAR_DOWN_DURATION
, MRO.UOM_CODE
, MRO.STANDARD_OPERATION_CODE
, MR.ASSEMBLY_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(MR.ASSEMBLY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MR.LINE_ID
, MSC_GET_NAME.DEPARTMENT_CODE(1
, MR.LINE_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, DECODE(MRO.USE_IN_PLAN
, NULL
, NULL
, MFG.MEANING)
FROM MSC_ROUTINGS MR
, MSC_ROUTING_OPERATIONS MRO
, MFG_LOOKUPS MFG
WHERE MR.PLAN_ID = MRO.PLAN_ID
AND MR.ROUTING_SEQUENCE_ID = MRO.ROUTING_SEQUENCE_ID
AND MR.SR_INSTANCE_ID = MRO.SR_INSTANCE_ID
AND NOT EXISTS (SELECT 1
FROM MSC_OPERATION_COMPONENTS MOC
WHERE MOC.PLAN_ID = MRO.PLAN_ID
AND MOC.OPERATION_SEQUENCE_ID = MRO.OPERATION_SEQUENCE_ID
AND MOC.SR_INSTANCE_ID = MRO.SR_INSTANCE_ID
AND MOC.ROUTING_SEQUENCE_ID = MRO.ROUTING_SEQUENCE_ID)
AND NVL(MRO.USE_IN_PLAN
, 1) = MFG.LOOKUP_CODE
AND MFG.LOOKUP_TYPE = 'SYS_YES_NO'

Columns