DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_DEMANDS

Line 1997: FROM msc_demands md

1993: md.using_assembly_demand_date,2), 0.01), 0) days_late,
1994: nvl(to_char(md.quantity_by_due_date),'null') qty_by_due_date,
1995: msc_get_name.org_code(md.organization_id, md.sr_instance_id) org,
1996: nvl(md.demand_class,'null') demand_class
1997: FROM msc_demands md
1998: WHERE md.plan_id = p_plan_id
1999: AND md.demand_id = v_demand_id
2000: AND md.sr_instance_id =v_instance_id
2001: ;

Line 4279: msc_demands md,

4275: nvl(ms.supplier_id,-1)
4276: from msc_full_pegging mfp1,
4277: msc_full_pegging mfp2,
4278: msc_supplies ms,
4279: msc_demands md,
4280: msc_system_items msi,
4281: msc_critical_paths mcp,
4282: msc_form_query mfq
4283: where mfp1.plan_id = p_plan_id

Line 4400: msc_demands md,

4396: from msc_full_pegging mfp1,
4397: msc_full_pegging mfp2,
4398: msc_system_items msi,
4399: msc_supplies ms,
4400: msc_demands md,
4401: msc_form_query mfq
4402: where mfp1.plan_id = p_plan_id
4403: and mfp1.transaction_id = p_supply_id
4404: and mfp1.end_pegging_id = mfq.number1

Line 5736: from msc_demands md,

5732: md.using_requirement_quantity||')',
5733: to_char(md.using_assembly_demand_date,format_mask),
5734: to_char(nvl(md.dmd_satisfied_date,md.using_assembly_demand_date),format_mask),
5735: demand_priority
5736: from msc_demands md,
5737: msc_items mi,
5738: msc_trading_partners mtp
5739: where md.demand_id = p_demand_id
5740: and md.plan_id = p_plan_id

Line 6040: msc_demands md,

6036: md.using_assembly_demand_date
6037: bulk collect into v_demand_id, v_order_name , v_dummy_date
6038: FROM
6039: msc_exception_details med,
6040: msc_demands md,
6041: msc_demands md2
6042: where md2.plan_id = p_plan_id
6043: and md2.demand_id = p_demand_id
6044: and med.plan_id = md2.plan_id

Line 6041: msc_demands md2

6037: bulk collect into v_demand_id, v_order_name , v_dummy_date
6038: FROM
6039: msc_exception_details med,
6040: msc_demands md,
6041: msc_demands md2
6042: where md2.plan_id = p_plan_id
6043: and md2.demand_id = p_demand_id
6044: and med.plan_id = md2.plan_id
6045: and med.organization_id = md2.organization_id

Line 6326: FROM msc_demands md,

6322: p_instance_id number,
6323: p_transaction_id number) return number is
6324: CURSOR dmd_cur IS
6325: SELECT min(md.demand_priority)
6326: FROM msc_demands md,
6327: msc_full_pegging mfp2,
6328: msc_full_pegging mfp1
6329: WHERE mfp1.plan_id = p_plan_id
6330: and mfp1.transaction_id = p_transaction_id