DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_OPERATION_NETWORKS

Line 6426: from msc_operation_networks mon

6422: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num < mrr1.operation_seq_num)
6423: or ( nvl(mr.cfm_routing_flag,2) = 3
6424: and mrr2.operation_sequence_id in (
6425: select mon.from_op_seq_id
6426: from msc_operation_networks mon
6427: where mon.plan_id = mrr1.plan_id
6428: and mon.sr_instance_id = mrr1.sr_instance_id
6429: and mon.routing_sequence_id = mrr1.routing_sequence_id
6430: and mon.to_op_seq_id = mrr1.operation_sequence_id

Line 6474: select mon.to_op_seq_id from msc_operation_networks mon

6470: and mr.sr_instance_id = mrr1.sr_instance_id
6471: and mr.routing_sequence_id = mrr1.routing_sequence_id
6472: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num > mrr1.operation_seq_num)
6473: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
6474: select mon.to_op_seq_id from msc_operation_networks mon
6475: where mon.plan_id = mrr1.plan_id
6476: and mon.sr_instance_id = mrr1.sr_instance_id
6477: and mon.routing_sequence_id = mrr1.routing_sequence_id
6478: and mon.from_op_seq_id = mrr1.operation_sequence_id

Line 6585: from msc_operation_networks mon

6581: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num < mrr1.operation_seq_num)
6582: or ( nvl(mr.cfm_routing_flag,2) = 3
6583: and mrr2.operation_sequence_id in (
6584: select mon.from_op_seq_id
6585: from msc_operation_networks mon
6586: where mon.plan_id = mrr1.plan_id
6587: and mon.sr_instance_id = mrr1.sr_instance_id
6588: and mon.routing_sequence_id = mrr1.routing_sequence_id
6589: and mon.to_op_seq_id = mrr1.operation_sequence_id

Line 6661: select mon.to_op_seq_id from msc_operation_networks mon

6657: and mr.sr_instance_id = mrr1.sr_instance_id
6658: and mr.routing_sequence_id = mrr1.routing_sequence_id
6659: and (((nvl(mr.cfm_routing_flag,2) <> 3 and mrr2.operation_seq_num > mrr1.operation_seq_num)
6660: or ( nvl(mr.cfm_routing_flag,2) = 3 and mrr2.operation_sequence_id in (
6661: select mon.to_op_seq_id from msc_operation_networks mon
6662: where mon.plan_id = mrr1.plan_id
6663: and mon.sr_instance_id = mrr1.sr_instance_id
6664: and mon.routing_sequence_id = mrr1.routing_sequence_id
6665: and mon.from_op_seq_id = mrr1.operation_sequence_id

Line 8778: msc_operation_networks mon

8774:
8775: cursor c_intra_rtg is
8776: select distinct mon.dependency_type
8777: from msc_resource_requirements mrr,
8778: msc_operation_networks mon
8779: where mrr.plan_id = p_plan_id
8780: and mrr.sr_instance_id = p_inst_id
8781: and mrr.supply_id = p_trans_id
8782: and mon.plan_id = mrr.plan_id