DBA Data[Home] [Help]

APPS.MSC_GANTT_PKG dependencies on MSC_OPERATION_NETWORKS

Line 178: from msc_operation_networks mon,

174: and number1 = x_supply_id
175: /*
176: and number2 not in
177: (select mon.to_op_seq_num
178: from msc_operation_networks mon,
179: msc_resource_requirements mrr
180: where mrr.plan_id = x_plan_id
181: and mrr.sr_instance_id = x_inst_id
182: and mrr.supply_id = x_supply_id

Line 197: -- op node ids from msc_operation_networks for intra routing

193: order by number2;
194: */
195: order by date1;
196:
197: -- op node ids from msc_operation_networks for intra routing
198: cursor ops_intra_routing_cur (x_supply_id number, x_plan_id number, x_inst_id number) is
199: select
200: mon.from_op_seq_num,
201: mgq1.row_index from_index,

Line 205: from msc_operation_networks mon,

201: mgq1.row_index from_index,
202: mon.to_op_seq_num,
203: mgq2.row_index to_index,
204: mon.dependency_type
205: from msc_operation_networks mon,
206: msc_resource_requirements mrr,
207: msc_gantt_query mgq1,
208: msc_gantt_query mgq2
209: where mrr.plan_id = x_plan_id