APPS.INV_SERIAL_PICK_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 40: from mtl_txn_request_lines

36:
37: BEGIN
38: select txn_source_line_id
39: into l_txn_source_line_id
40: from mtl_txn_request_lines
41: where line_id = p_move_order_line_id;
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF (l_debug = 1) THEN

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,'@@@@')

Line 1186: from mtl_txn_request_lines

1182:
1183: BEGIN
1184: select organization_id,from_subinventory_code,from_locator_id
1185: into l_organization_id,l_sub_code,l_locator_id
1186: from mtl_txn_request_lines
1187: where line_id = p_move_order_line_id;
1188: EXCEPTION
1189: WHEN NO_DATA_FOUND THEN
1190: IF (l_debug = 1) THEN