558: AND ( ' || p_range_buyer || ' ) ';
559:
560:
561: -- Report columns
562: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
563: l_catg_disp VARCHAR2(300);
564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
560:
561: -- Report columns
562: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
563: l_catg_disp VARCHAR2(300);
564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
561: -- Report columns
562: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;
563: l_catg_disp VARCHAR2(300);
564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
563: l_catg_disp VARCHAR2(300);
564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
572:
565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_qty%TYPE;
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
572:
573: l_err_msg VARCHAR2(2000);
566:
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
572:
573: l_err_msg VARCHAR2(2000);
574: l_vmi_enabled VARCHAR2(1);
567: l_stat INV_MIN_MAX_TEMP.error%TYPE;
568: l_supply_qty INV_MIN_MAX_TEMP.supply_qty%TYPE;
569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%TYPE;
570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_qty%TYPE;
571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;
572:
573: l_err_msg VARCHAR2(2000);
574: l_vmi_enabled VARCHAR2(1);
575:
801: , 'run_min_max_plan'
802: , 7);
803:
804: --
805: -- Insert into the global temp table INV_MIN_MAX_TEMP (defined
806: -- in patch/115/sql/invmmxtb.sql).
807: --
808: INSERT INTO INV_MIN_MAX_TEMP (
809: ITEM_SEGMENTS
804: --
805: -- Insert into the global temp table INV_MIN_MAX_TEMP (defined
806: -- in patch/115/sql/invmmxtb.sql).
807: --
808: INSERT INTO INV_MIN_MAX_TEMP (
809: ITEM_SEGMENTS
810: , DESCRIPTION
811: , ERROR
812: , SORTEE