DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_OPERATION_NETWORKS

Line 2462: select mon.from_op_seq_id from msc_operation_networks mon

2458: and mr.sr_instance_id = mrr1.sr_instance_id
2459: and mr.routing_sequence_id = mrr1.routing_sequence_id
2460: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num < mrr1.operation_seq_num)
2461: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
2462: select mon.from_op_seq_id from msc_operation_networks mon
2463: where mon.plan_id = mrr1.plan_id
2464: and mon.sr_instance_id = mrr1.sr_instance_id
2465: and mon.routing_sequence_id = mrr1.routing_sequence_id
2466: and mon.to_op_seq_id = mrr1.operation_sequence_id

Line 2514: select mon.to_op_seq_id from msc_operation_networks mon

2510: and mr.sr_instance_id = mrr1.sr_instance_id
2511: and mr.routing_sequence_id = mrr1.routing_sequence_id
2512: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num > mrr1.operation_seq_num)
2513: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
2514: select mon.to_op_seq_id from msc_operation_networks mon
2515: where mon.plan_id = mrr1.plan_id
2516: and mon.sr_instance_id = mrr1.sr_instance_id
2517: and mon.routing_sequence_id = mrr1.routing_sequence_id
2518: and mon.from_op_seq_id = mrr1.operation_sequence_id