APPS.INV_RCV_STD_INSPECT_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 228: UPDATE mtl_transaction_lots_interface

224: IF (l_debug = 1) THEN
225: print_debug('process_lot_serial_intf 1.2: serial_control_code IS 6, need TO NULL OUT mtli', 4);
226: END IF;
227:
228: UPDATE mtl_transaction_lots_interface
229: SET serial_transaction_temp_id = NULL
230: WHERE product_transaction_id = l_product_txn_id
231: AND product_code = 'RCV';
232: END IF; -- IF (l_is_rma = 1)

Line 1571: FROM mtl_transaction_lots_interface mtli,

1567: THEN
1568: BEGIN
1569: SELECT SUM (NVL (mtli.primary_quantity, 0))
1570: INTO l_processed_lot_prim_qty
1571: FROM mtl_transaction_lots_interface mtli,
1572: rcv_transactions_interface rti
1573: WHERE mtli.product_code = 'RCV'
1574: AND mtli.product_transaction_id =
1575: rti.interface_transaction_id

Line 2638: FROM mtl_transaction_lots_interface mtli

2634: ELSIF (l_lot_number IS NOT NULL) THEN
2635: BEGIN
2636: SELECT SUM(Nvl(mtli.primary_quantity,0))
2637: INTO l_processed_lot_prim_qty
2638: FROM mtl_transaction_lots_interface mtli
2639: , rcv_transactions_interface rti
2640: WHERE mtli.product_code = 'RCV'
2641: AND mtli.product_transaction_id = rti.interface_transaction_id
2642: AND mtli.lot_number = l_lot_number