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_QUANTITY_TREE_PVT dependencies on MTL_RSV_QUANTITIES_TEMP

Line 11244: -- which has ATR > 0. The table mtl_rsv_quantities_temp

11240: -- This procedure is called from the reservation form to
11241: -- initialize the table used for the LOVs in that form.
11242: --
11243: -- This procedure inserts one record for every node in the tree
11244: -- which has ATR > 0. The table mtl_rsv_quantities_temp
11245: -- is a session specific global temp table which serves as the
11246: -- basis for the LOVs in the Reservations form.
11247: --
11248: PROCEDURE prepare_reservation_quantities(

Line 11279: DELETE FROM MTL_RSV_QUANTITIES_TEMP;

11275: print_debug(l_api_name || ' Entered',9);
11276: END IF;
11277:
11278: -- clear out temp table
11279: DELETE FROM MTL_RSV_QUANTITIES_TEMP;
11280:
11281: -- find root node
11282: l_root_id := g_demand_info(p_tree_id).root_id;
11283:

Line 11306: print_debug('insert into mtl_rsv_quantities_temp, item='||g_rootinfos(l_root_id).inventory_item_id);

11302: traverse(l_item_node, NULL, NULL);
11303:
11304: -- Bug 8593965: Using bulk insert to test the performance
11305: if g_debug = 1 then
11306: print_debug('insert into mtl_rsv_quantities_temp, item='||g_rootinfos(l_root_id).inventory_item_id);
11307: end if;
11308:
11309: l_prev_lot_number := '@@@@';
11310: l_prev_grade_code := '@@@@';

Line 11338: INSERT INTO MTL_RSV_QUANTITIES_TEMP (

11334: END LOOP;
11335:
11336: --insert into table
11337: FORALL i in 1..g_rsv_qty_counter
11338: INSERT INTO MTL_RSV_QUANTITIES_TEMP (
11339: organization_id
11340: ,inventory_item_id
11341: ,node_level
11342: ,revision