[Home] [Help]
67:
68: l_stmt_id :=5;
69: select trunc(mp.curr_start_date),trunc(mp.curr_cutoff_date)
70: into l_curr_start_date,l_curr_cutoff_date
71: from msc_plans mp where mp.plan_id=p_plan_id;
72:
73:
74: l_stmt_id :=10;
75: ----------------------------------------------------
409: where f_1.query_id(+) = l_qid_vmi
410: and f_1.number1(+) = msi_1.plan_id
411: and f_1.number3(+) = msi_1.sr_instance_id
412: and f_1.number4(+) = msi_1.organization_id
413: and f_1.number5(+) = msi_1.inventory_item_id) msi, msc_plans mp
414: where ms.plan_id = msi.plan_id
415: and ms.sr_instance_id = msi.sr_instance_id
416: and ms.organization_id =msi.organization_id
417: and ms.inventory_item_id = msi.inventory_item_id
528: decode(ms2.last_unit_completion_date,null, ms2.new_order_quantity,ms2.daily_rate) ),
529: decode(ms2.last_unit_completion_date,null, ms2.new_order_quantity,ms2.daily_rate) ))),
530: 0),0)) drp_supply_as_demand,
531: to_number(null) stockout_days
532: from msc_supplies ms2,msc_plans mp,
533: ( select msi_2.plan_id,
534: msi_2.sr_instance_id,
535: msi_2.organization_id,
536: msi_2.inventory_item_id,
565: trunc(nvl(ms2.firm_date,ms2.new_schedule_date)),
566: ms2.order_type,
567: msi2.vmi_flag
568: order by 1,2,3,4,5,6,7,8,9,10) supply_tbl,
569: msc_plans mp,
570: msc_phub_suppliers_mv mps
571: where mp.plan_id=p_plan_id --- we need this to separate io measure from other measures
572: and mps.supplier_id = nvl(supply_tbl.supplier_id, -23453)
573: and mps.supplier_site_id = nvl(supply_tbl.supplier_site_id, -23453)
744: and f_1.number1(+) = msi_1.plan_id
745: and f_1.number3(+) = msi_1.sr_instance_id
746: and f_1.number4(+) = msi_1.organization_id
747: and f_1.number5(+) = msi_1.inventory_item_id) msi,
748: msc_plans mp
749: where ms.plan_id = msi.plan_id
750: and ms.sr_instance_id = msi.sr_instance_id
751: and ms.organization_id =msi.organization_id
752: and ms.inventory_item_id = msi.inventory_item_id