DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 4715: delete from mtl_serial_numbers_temp

4711: END IF;
4712:
4713: -- Bug 5748351: Deleting MSNT/MTLT/MMTT for the headerId, in case they are still present and did not
4714: -- get deleted in TM.
4715: delete from mtl_serial_numbers_temp
4716: where transaction_temp_id in (
4717: select mmtt.transaction_temp_id
4718: from mtl_material_transactions_temp mmtt
4719: where mmtt.transaction_header_id = l_header_id );

Line 4721: delete from mtl_serial_numbers_temp

4717: select mmtt.transaction_temp_id
4718: from mtl_material_transactions_temp mmtt
4719: where mmtt.transaction_header_id = l_header_id );
4720:
4721: delete from mtl_serial_numbers_temp
4722: where transaction_temp_id in (
4723: select mtlt.serial_transaction_temp_id
4724: from mtl_transaction_lots_temp mtlt
4725: where mtlt.transaction_temp_id in (