DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on INV_MIN_MAX_TEMP

Line 562: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;

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:

Line 564: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;

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;

Line 565: l_onhand_qty INV_MIN_MAX_TEMP.onhand_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;

Line 567: l_stat INV_MIN_MAX_TEMP.error%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;

Line 568: l_supply_qty INV_MIN_MAX_TEMP.supply_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:

Line 569: l_demand_qty INV_MIN_MAX_TEMP.demand_qty%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:
573: l_err_msg VARCHAR2(2000);

Line 570: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_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);
574: l_vmi_enabled VARCHAR2(1);

Line 571: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;

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:

Line 805: -- Insert into the global temp table INV_MIN_MAX_TEMP (defined

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

Line 808: INSERT INTO INV_MIN_MAX_TEMP (

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