APPS.MSC_GANTT_UTILS dependencies on MSC_DEMANDS

Line 375: msc_demands md

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

Line 1602: from msc_demands md,

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

Line 8506: from msc_demands md

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

Line 9989: from msc_demands md,

9985: md.organization_id,
9986: md.inventory_item_id,
9987: md.demand_class,
9988: md.dmd_satisfied_date material_avail_date
9989: from msc_demands md,
9990: msc_system_items msi,
9991: msc_item_categories mic,
9992: msc_trading_partners mtp,
9993: msc_gantt_query mgq