DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_OPERATION_NETWORKS

Line 6421: from msc_operation_networks mon

6417: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num < mrr1.operation_seq_num)
6418: or ( nvl(mr.cfm_routing_flag,2) = 3
6419: and mrr2.operation_sequence_id in (
6420: select mon.from_op_seq_id
6421: from msc_operation_networks mon
6422: where mon.plan_id = mrr1.plan_id
6423: and mon.sr_instance_id = mrr1.sr_instance_id
6424: and mon.routing_sequence_id = mrr1.routing_sequence_id
6425: and mon.to_op_seq_id = mrr1.operation_sequence_id

Line 6469: select mon.to_op_seq_id from msc_operation_networks mon

6465: and mr.sr_instance_id = mrr1.sr_instance_id
6466: and mr.routing_sequence_id = mrr1.routing_sequence_id
6467: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num > mrr1.operation_seq_num)
6468: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
6469: select mon.to_op_seq_id from msc_operation_networks mon
6470: where mon.plan_id = mrr1.plan_id
6471: and mon.sr_instance_id = mrr1.sr_instance_id
6472: and mon.routing_sequence_id = mrr1.routing_sequence_id
6473: and mon.from_op_seq_id = mrr1.operation_sequence_id

Line 6580: from msc_operation_networks mon

6576: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num < mrr1.operation_seq_num)
6577: or ( nvl(mr.cfm_routing_flag,2) = 3
6578: and mrr2.operation_sequence_id in (
6579: select mon.from_op_seq_id
6580: from msc_operation_networks mon
6581: where mon.plan_id = mrr1.plan_id
6582: and mon.sr_instance_id = mrr1.sr_instance_id
6583: and mon.routing_sequence_id = mrr1.routing_sequence_id
6584: and mon.to_op_seq_id = mrr1.operation_sequence_id

Line 6656: select mon.to_op_seq_id from msc_operation_networks mon

6652: and mr.sr_instance_id = mrr1.sr_instance_id
6653: and mr.routing_sequence_id = mrr1.routing_sequence_id
6654: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num > mrr1.operation_seq_num)
6655: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
6656: select mon.to_op_seq_id from msc_operation_networks mon
6657: where mon.plan_id = mrr1.plan_id
6658: and mon.sr_instance_id = mrr1.sr_instance_id
6659: and mon.routing_sequence_id = mrr1.routing_sequence_id
6660: and mon.from_op_seq_id = mrr1.operation_sequence_id

Line 8773: msc_operation_networks mon

8769:
8770: cursor c_intra_rtg is
8771: select distinct mon.dependency_type
8772: from msc_resource_requirements mrr,
8773: msc_operation_networks mon
8774: where mrr.plan_id = p_plan_id
8775: and mrr.sr_instance_id = p_inst_id
8776: and mrr.supply_id = p_trans_id
8777: and mon.plan_id = mrr.plan_id