APPS.INV_SELECT_INVENTORY_PKG dependencies on MTL_AVAILABLE_INVENTORY_TEMP

Line 80: INSERT INTO mtl_available_inventory_temp

76: PROCEDURE get_details (V_move_order_line_id IN NUMBER, X_return_status OUT NOCOPY VARCHAR2) IS
77: BEGIN
78: X_return_status := FND_API.G_RET_STS_SUCCESS;
79: -- Bug#12831673. Added lpn_id
80: INSERT INTO mtl_available_inventory_temp
81: (transaction_temp_id,source_line_id,move_order_line_id,organization_id,inventory_item_id,
82: transaction_source_type_id,transaction_action_id,lot_number,subinventory_code,lot_created,
83: lot_expiration_date,grade_code,locator_id,onhand_qty,secondary_onhand_qty,reason_id,
84: transaction_qty,secondary_transaction_qty,transaction_uom,secondary_uom,revision,order_by,lpn_id)

Line 172: from mtl_available_inventory_temp

168: BEGIN
169:
170: select 1
171: into l_found
172: from mtl_available_inventory_temp
173: where (revision = WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).revision or
174: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).revision is null )
175: and (lot_number = WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number or
176: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number is null)

Line 287: INSERT INTO mtl_available_inventory_temp

283:
284: IF (l_insert_allowed) THEN
285:
286:
287: INSERT INTO mtl_available_inventory_temp
288: ( revision
289: , lot_number
290: , lot_expiration_date
291: , subinventory_code