DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 172: UPDATE mtl_transaction_lots_interface

168: IF (l_debug = 1) THEN
169: print_debug('process_lot_serial_intf 1.2: serial_control_code IS 6, need TO NULL OUT mtli', 4);
170: END IF;
171:
172: UPDATE mtl_transaction_lots_interface
173: SET serial_transaction_temp_id = NULL
174: WHERE product_transaction_id = l_product_txn_id
175: AND product_code = 'RCV';
176: END IF; -- IF (l_is_rma = 1)

Line 748: FROM mtl_transaction_lots_interface mtli

744: ELSIF (l_lot_number IS NOT NULL) THEN
745: BEGIN
746: SELECT SUM(Nvl(mtli.primary_quantity,0))
747: INTO l_processed_lot_prim_qty
748: FROM mtl_transaction_lots_interface mtli
749: , rcv_transactions_interface rti
750: WHERE mtli.product_code = 'RCV'
751: AND mtli.product_transaction_id = rti.interface_transaction_id
752: AND mtli.lot_number = l_lot_number