APPS.MSC_GANTT_PKG dependencies on MSC_DEMANDS

Line 125: from msc_demands md

121: cursor demand_cur (x_plan_id number, x_demand_id number) is
122: select md.sr_instance_id,
123: md.organization_id,
124: md.demand_id
125: from msc_demands md
126: where md.demand_id = x_demand_id
127: and md.plan_id = x_plan_id
128: and md.origination_type in (6,7,8,9,11,15,22,29,30);
129:

Line 137: from msc_demands md,

133: select md.sr_instance_id,
134: md.organization_id,
135: md.demand_id,
136: md.using_assembly_demand_date start_date
137: from msc_demands md,
138: msc_full_pegging mfp1
139: where mfp1.plan_id = x_plan_id
140: and mfp1.transaction_id = x_supply_id
141: and mfp1.sr_instance_id = x_instance_id

Line 443: -- get op/supply from msc_demands

439: where mgq.query_id = g_order_query_id
440: and mgq.transaction_id = ms.transaction_id)
441: order by ms.new_wip_start_date;
442:
443: -- get op/supply from msc_demands
444: cursor op_supp_same_down_cur (x_plan_id number,
445: x_instance_id number, x_supply_id number,
446: x_end_peg_query_id number, x_first_op number) is
447: select distinct

Line 457: msc_demands md,

453: ms.transaction_id, ms.sr_instance_id) critical_supply
454: from msc_full_pegging mfp1,
455: msc_full_pegging mfp2,
456: msc_supplies ms,
457: msc_demands md,
458: msc_form_query mfq
459: where mfp1.plan_id = x_plan_id
460: and mfp1.transaction_id = x_supply_id
461: and mfp1.sr_instance_id = x_instance_id

Line 475: -- get op/supply from msc_demands

471: and ms.plan_id = mfp2.plan_id
472: and ms.transaction_id = mfp2.transaction_id
473: and ms.sr_instance_id = mfp2.sr_instance_id;
474:
475: -- get op/supply from msc_demands
476: cursor op_supp_diff_down_cur (x_plan_id number,
477: x_instance_id number, x_supply_id number,
478: x_end_peg_query_id number, x_first_op number) is
479: select distinct

Line 489: msc_demands md

485: ms.transaction_id, ms.sr_instance_id) critical_supply
486: from msc_full_pegging mfp1,
487: msc_full_pegging mfp2,
488: msc_supplies ms,
489: msc_demands md
490: where mfp1.plan_id = x_plan_id
491: and mfp1.transaction_id = x_supply_id
492: and mfp1.sr_instance_id = x_instance_id
493: and md.plan_id = mfp1.plan_id