DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_RSV_QUANTITIES_TEMP

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

10735: -- This procedure is called from the reservation form to
10736: -- initialize the table used for the LOVs in that form.
10737: --
10738: -- This procedure inserts one record for every node in the tree
10739: -- which has ATR > 0. The table mtl_rsv_quantities_temp
10740: -- is a session specific global temp table which serves as the
10741: -- basis for the LOVs in the Reservations form.
10742: --
10743: PROCEDURE prepare_reservation_quantities(

Line 10771: DELETE FROM MTL_RSV_QUANTITIES_TEMP;

10767: print_debug(l_api_name || ' Entered',9);
10768: END IF;
10769:
10770: -- clear out temp table
10771: DELETE FROM MTL_RSV_QUANTITIES_TEMP;
10772:
10773: -- find root node
10774: l_root_id := g_demand_info(p_tree_id).root_id;
10775:

Line 10810: print_debug(' insert into mtl_rsv_quantities_temp, item='||g_rootinfos(l_root_id).inventory_item_id||', revision='||g_rsv_qty_revision(i)||'...');

10806: --INTO l_grade_code;
10807: CLOSE Get_Grade_From_Lot;
10808: END IF;
10809:
10810: print_debug(' insert into mtl_rsv_quantities_temp, item='||g_rootinfos(l_root_id).inventory_item_id||', revision='||g_rsv_qty_revision(i)||'...');
10811: INSERT INTO MTL_RSV_QUANTITIES_TEMP (
10812: organization_id
10813: ,inventory_item_id
10814: ,node_level

Line 10811: INSERT INTO MTL_RSV_QUANTITIES_TEMP (

10807: CLOSE Get_Grade_From_Lot;
10808: END IF;
10809:
10810: print_debug(' insert into mtl_rsv_quantities_temp, item='||g_rootinfos(l_root_id).inventory_item_id||', revision='||g_rsv_qty_revision(i)||'...');
10811: INSERT INTO MTL_RSV_QUANTITIES_TEMP (
10812: organization_id
10813: ,inventory_item_id
10814: ,node_level
10815: ,revision