APPS.MSC_GANTT_UTILS dependencies on MSC_DEMANDS

Line 376: msc_demands md

372: md.organization_id,
373: md.demand_id,
374: END_DEMAND_NODE nodetype
375: from msc_form_query mfq,
376: msc_demands md
377: where mfq.query_id = p_mfq_query_id
378: and mfq.NUMBER2 = md.sr_instance_id
379: and mfq.NUMBER1 = md.demand_id
380: and md.plan_id = p_plan_id;

Line 1603: from msc_demands md,

1599: p_instance_id number, p_transaction_id number) return number is
1600:
1601: cursor dmd_cur is
1602: select min(md.demand_priority)
1603: from msc_demands md,
1604: msc_full_pegging mfp2,
1605: msc_full_pegging mfp1
1606: where mfp1.plan_id = p_plan_id
1607: and mfp1.transaction_id = p_transaction_id

Line 8511: from msc_demands md

8507: 1, GREATEST(round(md.dmd_satisfied_date - md.using_assembly_demand_date,2), 0.01), 0) days_late,
8508: nvl(to_char(md.quantity_by_due_date),null_space) qty_by_due_date,
8509: msc_get_name.org_code(md.organization_id, md.sr_instance_id) org,
8510: nvl(md.demand_class,null_space) demand_class
8511: from msc_demands md
8512: where md.plan_id = p_plan_id
8513: and md.demand_id = v_demand_id
8514: and md.sr_instance_id = v_instance_id;
8515:

Line 9994: from msc_demands md,

9990: md.organization_id,
9991: md.inventory_item_id,
9992: md.demand_class,
9993: md.dmd_satisfied_date material_avail_date
9994: from msc_demands md,
9995: msc_system_items msi,
9996: msc_item_categories mic,
9997: msc_trading_partners mtp,
9998: msc_gantt_query mgq