Query to Delete orphan transaction records from pending transaction form

 

Select * from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787);

Delete from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787);

select * from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787);

Delete from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787);

Commit;