APPS.MSC_ITEM_PKG dependencies on MSC_DEMANDS_F

Line 437: from msc_demands_f

433: f.number11 --days in bucket
434: from
435: (select distinct sr_instance_id, organization_id, inventory_item_id,
436: nvl(vmi_flag, 0) vmi_flag
437: from msc_demands_f
438: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type=0
439: and sr_instance_id=c.sr_instance_id and organization_id=c.organization_id
440: union
441: select distinct sr_instance_id, organization_id, inventory_item_id,

Line 534: from msc_demands_f mdf

530: mdf.organization_id,
531: mdf.inventory_item_id,
532: nvl(mdf.vmi_flag,0) vmi_flag,
533: mdf.order_date activity_date
534: from msc_demands_f mdf
535: where mdf.plan_id= p_plan_id
536: and mdf.plan_run_id = p_plan_run_id
537: and mdf.aggr_type=0
538: union

Line 602: from msc_demands_f mdf

598: mdf.sr_instance_id,
599: mdf.organization_id,
600: mdf.inventory_item_id,
601: nvl(mdf.vmi_flag,0) vmi_flag
602: from msc_demands_f mdf
603: where mdf.plan_id= p_plan_id
604: and mdf.plan_run_id = p_plan_run_id
605: and mdf.aggr_type=0
606: union

Line 860: from msc_demands_f mdf,msc_hub_query mfq1,

856: 0)) sales_order_Qty,
857: sum(decode(nvl(mdf.order_type,0),
858: -29,nvl(mdf.demand_qty,0),
859: 0)) forecast_Qty
860: from msc_demands_f mdf,msc_hub_query mfq1,
861: msc_plans mpd
862: where mfq1.number1 = mdf.plan_id(+)
863: and mfq1.number2 = mdf.plan_run_id(+)
864: and mfq1.number3 = mdf.sr_instance_id(+)

Line 1059: from msc_Demands_f mdf

1055: mdf.sr_instance_id,
1056: mdf.organization_id,
1057: mdf.inventory_item_id,
1058: sum(nvl(mdf.demand_qty,0)) / l_plan_days
1059: from msc_Demands_f mdf
1060: where mdf.plan_id = p_plan_id
1061: and mdf.plan_run_id = p_plan_run_id
1062: group by
1063: l_qid_others,