DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 4574: delete from mtl_serial_numbers_temp

4570: END IF;
4571:
4572: -- Bug 5748351: Deleting MSNT/MTLT/MMTT for the headerId, in case they are still present and did not
4573: -- get deleted in TM.
4574: delete from mtl_serial_numbers_temp
4575: where transaction_temp_id in (
4576: select mmtt.transaction_temp_id
4577: from mtl_material_transactions_temp mmtt
4578: where mmtt.transaction_header_id = l_header_id );

Line 4580: delete from mtl_serial_numbers_temp

4576: select mmtt.transaction_temp_id
4577: from mtl_material_transactions_temp mmtt
4578: where mmtt.transaction_header_id = l_header_id );
4579:
4580: delete from mtl_serial_numbers_temp
4581: where transaction_temp_id in (
4582: select mtlt.serial_transaction_temp_id
4583: from mtl_transaction_lots_temp mtlt
4584: where mtlt.transaction_temp_id in (