592:
593: l_proc_name CONSTANT VARCHAR2(30) := 'RUN_MIN_MAX_PLAN';
594:
595: -- Report columns
596: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
597: l_catg_disp VARCHAR2(300);
598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
594:
595: -- Report columns
596: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
597: l_catg_disp VARCHAR2(300);
598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
595: -- Report columns
596: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
597: l_catg_disp VARCHAR2(300);
598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
597: l_catg_disp VARCHAR2(300);
598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
606:
599: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
606:
607: l_err_msg VARCHAR2(2000);
600:
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
606:
607: l_err_msg VARCHAR2(2000);
608: l_vmi_enabled VARCHAR2(1) := 'N';
601: l_stat INV_MIN_MAX_TEMP.error%TYPE;
602: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
603: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
606:
607: l_err_msg VARCHAR2(2000);
608: l_vmi_enabled VARCHAR2(1) := 'N';
609: BEGIN
868: , 7);
869: END IF;
870:
871: --
872: -- Insert into the global temp table INV_MIN_MAX_TEMP (defined
873: -- in patch/115/sql/invmmxtb.sql).
874: --
875: -- Replenishment Move Order Consolidation
876: -- only INSERT if the value of the new report parameter p_gen_report is 'Y'
879: -- kkoothan Bug Fix:2748471
880: -- Populated the value for the newly added column Subinventory_Code.
881: --
882: IF p_gen_report = 'Y' THEN
883: INSERT INTO INV_MIN_MAX_TEMP (
884: ITEM_SEGMENTS
885: , DESCRIPTION
886: , ERROR
887: , SORTEE