APPS.INV_SELECT_INVENTORY_PKG dependencies on MTL_AVAILABLE_INVENTORY_TEMP

Line 79: INSERT INTO mtl_available_inventory_temp

75:
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: INSERT INTO mtl_available_inventory_temp
80: (transaction_temp_id,source_line_id,move_order_line_id,organization_id,inventory_item_id,
81: transaction_source_type_id,transaction_action_id,lot_number,subinventory_code,lot_created,
82: lot_expiration_date,grade_code,locator_id,onhand_qty,secondary_onhand_qty,reason_id,
83: transaction_qty,secondary_transaction_qty,transaction_uom,secondary_uom,revision,order_by)

Line 148: INSERT INTO mtl_available_inventory_temp

144: gmi_reservation_util.println('fetch the rows, 2nd qty '
145: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
146: gmi_reservation_util.println('fetch the rows, grade_code '
147: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code);
148: INSERT INTO mtl_available_inventory_temp
149: ( revision
150: , lot_number
151: , lot_expiration_date
152: , subinventory_code