Oracle Inventory MTL Temporary Data Delete Script

--Oracle Inventory Material Transactions Temporary data Delete 

 --Check first 
SELECT * FROM MTL_TRANSACTIONS_TEMP_ALL_V; 

SELECT *
  FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
 WHERE TRANSACTION_TEMP_ID = 6651466;



---Delete from temp
DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
 WHERE TRANSACTION_TEMP_ID = 6651466;
 
COMMIT;