APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 10508: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

10504: inv_log_util.trace('going to insert lot'||p_header_id,'INV_TXN_MANAGER_GRP','9');
10505: END IF;
10506:
10507: /* Inserting LOT transactions */
10508: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
10509: (TRANSACTION_TEMP_ID,
10510: LOT_NUMBER,
10511: LOT_EXPIRATION_DATE,
10512: LAST_UPDATED_BY,

Line 12538: INSERT INTO mtl_transaction_lots_temp

12534: mydebug ('breadcrumb 50', 'tmpinsert2');
12535: mydebug ('Inserting into MTLI', 'tmpinsert2');
12536: END IF;
12537:
12538: INSERT INTO mtl_transaction_lots_temp
12539: (transaction_temp_id
12540: , lot_number
12541: , lot_expiration_date
12542: , last_updated_by

Line 13751: UPDATE mtl_transaction_lots_temp

13747: , 'tmpinsert2'
13748: );
13749: END IF;
13750:
13751: UPDATE mtl_transaction_lots_temp
13752: SET serial_transaction_temp_id = l_sequence
13753: WHERE transaction_temp_id = l_mtli_csr.transaction_interface_id;
13754: END IF; --if transaction lot split/merge
13755:

Line 13790: FROM mtl_transaction_lots_temp

13786: WHERE transaction_interface_id = l_mti_csr.parent_id;
13787:
13788: SELECT serial_transaction_temp_id
13789: INTO l_serial_temp_id
13790: FROM mtl_transaction_lots_temp
13791: WHERE transaction_temp_id = l_mtli_csr.transaction_interface_id;
13792:
13793: IF (l_debug = 1)
13794: THEN