APPS.INV_SERIAL_PICK_PKG dependencies on MTL_RESERVATIONS

Line 28: FROM mtl_reservations

24: l_txn_source_line_id NUMBER;
25: l_msg_count NUMBER;
26: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS
27: SELECT reservation_id
28: FROM mtl_reservations
29: WHERE nvl(staged_flag,'N') = 'N'
30: AND supply_source_type_id = 13
31: AND demand_source_type_id in (2,8)
32: AND demand_source_line_id = p_source_line_id;

Line 100: FROM mtl_reservations

96: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
97:
98: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS
99: SELECT reservation_id
100: FROM mtl_reservations
101: WHERE nvl(staged_flag,'N') = 'N'
102: AND supply_source_type_id = 13
103: AND demand_source_type_id in (2,8)
104: AND demand_source_line_id = p_source_line_id;

Line 228: FROM MTL_RESERVATIONS MRSV, MTL_TXN_REQUEST_LINES MTRL

224: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
225: -- Bug 7190635, Adding new cursor to fetch reservation id based on move order line id.
226: CURSOR mrsv_record is
227: SELECT MRSV.*
228: FROM MTL_RESERVATIONS MRSV, MTL_TXN_REQUEST_LINES MTRL
229: WHERE MTRL.LINE_ID = P_MOVE_ORDER_LINE_ID
230: AND MTRL.TXN_SOURCE_LINE_ID = MRSV.DEMAND_SOURCE_LINE_ID
231: AND Nvl(MRSV.inventory_item_id,'-9999') = Nvl(p_inventory_item_id,'-9999')
232: AND Nvl(MRSV.subinventory_code,'@@@@') = Nvl(p_subinventory_code,'@@@@')