APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 9937: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

9933: inv_log_util.trace('going to insert lot'||p_header_id,'INV_TXN_MANAGER_GRP','9');
9934: END IF;
9935:
9936: /* Inserting LOT transactions */
9937: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
9938: (TRANSACTION_TEMP_ID,
9939: LOT_NUMBER,
9940: LOT_EXPIRATION_DATE,
9941: LAST_UPDATED_BY,

Line 11967: INSERT INTO mtl_transaction_lots_temp

11963: mydebug ('breadcrumb 50', 'tmpinsert2');
11964: mydebug ('Inserting into MTLI', 'tmpinsert2');
11965: END IF;
11966:
11967: INSERT INTO mtl_transaction_lots_temp
11968: (transaction_temp_id
11969: , lot_number
11970: , lot_expiration_date
11971: , last_updated_by

Line 13180: UPDATE mtl_transaction_lots_temp

13176: , 'tmpinsert2'
13177: );
13178: END IF;
13179:
13180: UPDATE mtl_transaction_lots_temp
13181: SET serial_transaction_temp_id = l_sequence
13182: WHERE transaction_temp_id = l_mtli_csr.transaction_interface_id;
13183: END IF; --if transaction lot split/merge
13184:

Line 13219: FROM mtl_transaction_lots_temp

13215: WHERE transaction_interface_id = l_mti_csr.parent_id;
13216:
13217: SELECT serial_transaction_temp_id
13218: INTO l_serial_temp_id
13219: FROM mtl_transaction_lots_temp
13220: WHERE transaction_temp_id = l_mtli_csr.transaction_interface_id;
13221:
13222: IF (l_debug = 1)
13223: THEN