APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1298: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.

1294: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1295: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1296: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1297: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1298: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1299: --
1300: -- History :
1301: -- Person Date Descriptions
1302: -- ------ ---- --------------

Line 1359: from mtl_transaction_lots_temp

1355:
1356: Cursor l_Get_Lot_Temp_Csr IS
1357: select transaction_temp_id, serial_transaction_temp_id,
1358: lot_number, lot_expiration_date, transaction_quantity
1359: from mtl_transaction_lots_temp
1360: where transaction_temp_id = p_transaction_temp_id;
1361:
1362: Cursor l_Get_Serial_Temp_Csr(l_transaction_temp_id NUMBER) IS
1363: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp