Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | this view shows all the operations in the network routing |
Implementation/DBA Data: | APPS.MSC_OPERATION_NETWORKS_V |
SELECT MON.ROWID ROW_ID
, MON.ROUTING_SEQUENCE_ID
, MON.PLAN_ID
, MON.SR_INSTANCE_ID
, MON.FROM_OP_SEQ_ID
, MRO1.OPERATION_SEQ_NUM
, MRO1.STANDARD_OPERATION_CODE
, MON.TO_OP_SEQ_ID
, MRO2.OPERATION_SEQ_NUM
, MRO2.STANDARD_OPERATION_CODE
, DECODE(MON.TRANSITION_TYPE
, 1
, 'PRIMARY'
, 2
, 'ALTERNATE'
, NULL)
, MON.PLANNING_PCT
, MRO1.NET_PLANNING_PERCENT
, MON.CREATION_DATE
, MON.CREATED_BY
, MON.LAST_UPDATE_DATE
, MON.LAST_UPDATE_LOGIN
, MON.LAST_UPDATED_BY
, MON.ATTRIBUTE_CATEGORY
, MON.ATTRIBUTE1
, MON.ATTRIBUTE2
, MON.ATTRIBUTE3
, MON.ATTRIBUTE4
, MON.ATTRIBUTE5
, MON.ATTRIBUTE6
, MON.ATTRIBUTE7
, MON.ATTRIBUTE8
, MON.ATTRIBUTE9
, MON.ATTRIBUTE10
, MON.ATTRIBUTE11
, MON.ATTRIBUTE12
, MON.ATTRIBUTE13
, MON.ATTRIBUTE14
, MON.ATTRIBUTE15
FROM MSC_OPERATION_NETWORKS MON
, MSC_ROUTING_OPERATIONS MRO1
, MSC_ROUTING_OPERATIONS MRO2
WHERE MON.FROM_OP_SEQ_ID = MRO1.OPERATION_SEQUENCE_ID
AND MON.PLAN_ID = MRO1.PLAN_ID
AND MON.SR_INSTANCE_ID = MRO1.SR_INSTANCE_ID
AND MON.ROUTING_SEQUENCE_ID = MRO1.ROUTING_SEQUENCE_ID
AND MON.TO_OP_SEQ_ID = MRO2.OPERATION_SEQUENCE_ID
AND MON.PLAN_ID = MRO2.PLAN_ID
AND MON.SR_INSTANCE_ID = MRO2.SR_INSTANCE_ID
AND MON.ROUTING_SEQUENCE_ID = MRO2.ROUTING_SEQUENCE_ID