VIEW: APPS.MSC_OPERATION_NETWORKS_V

Source

View Text - Preformatted

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, msc_get_name.lookup_meaning('MSC_TRANSITION_TYPE',mon.transition_type), nvl(mon.planning_pct,mon.transfer_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, msc_get_name.lookup_meaning('MSC_DEPENDENCY_TYPE',mon.dependency_type), mon.minimum_time_offset, mon.maximum_time_offset, mon.transfer_pct, msc_get_name.lookup_meaning('SYS_YES_NO',mon.apply_to_charges) from msc_operation_networks mon, ( select distinct operation_seq_num, standard_operation_code, net_planning_percent, plan_id, routing_sequence_id , sr_instance_id from msc_routing_operations) mro1, ( select distinct operation_seq_num, standard_operation_code, net_planning_percent, plan_id, routing_sequence_id , sr_instance_id from msc_routing_operations) mro2 WHERE mon.from_op_seq_num = mro1.operation_seq_num 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_num = mro2.operation_seq_num 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 and mon.from_item_id is null

View Text - HTML Formatted

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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_TRANSITION_TYPE'
, MON.TRANSITION_TYPE)
, NVL(MON.PLANNING_PCT
, MON.TRANSFER_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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DEPENDENCY_TYPE'
, MON.DEPENDENCY_TYPE)
, MON.MINIMUM_TIME_OFFSET
, MON.MAXIMUM_TIME_OFFSET
, MON.TRANSFER_PCT
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MON.APPLY_TO_CHARGES)
FROM MSC_OPERATION_NETWORKS MON
, ( SELECT DISTINCT OPERATION_SEQ_NUM
, STANDARD_OPERATION_CODE
, NET_PLANNING_PERCENT
, PLAN_ID
, ROUTING_SEQUENCE_ID
, SR_INSTANCE_ID
FROM MSC_ROUTING_OPERATIONS) MRO1
, ( SELECT DISTINCT OPERATION_SEQ_NUM
, STANDARD_OPERATION_CODE
, NET_PLANNING_PERCENT
, PLAN_ID
, ROUTING_SEQUENCE_ID
, SR_INSTANCE_ID
FROM MSC_ROUTING_OPERATIONS) MRO2
WHERE MON.FROM_OP_SEQ_NUM = MRO1.OPERATION_SEQ_NUM
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_NUM = MRO2.OPERATION_SEQ_NUM
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
AND MON.FROM_ITEM_ID IS NULL