eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on INV_MIN_MAX_TEMP

Line 596: l_item_segments INV_MIN_MAX_TEMP.item_segments%TYPE;

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:

Line 598: l_sortee INV_MIN_MAX_TEMP.sortee%TYPE;

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;

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

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

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

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

Line 604: l_tot_avail_qty INV_MIN_MAX_TEMP.tot_avail_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);
608: l_vmi_enabled VARCHAR2(1) := 'N';

Line 605: l_reord_qty INV_MIN_MAX_TEMP.reord_qty%TYPE;

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

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

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'

Line 883: INSERT INTO INV_MIN_MAX_TEMP (

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