Step 1: Query the record which needs to be updated
SELECT
TRANSACTION_DATE, MTI.*
TRANSACTION_DATE, MTI.*
FROM MTL_TRANSACTIONS_INTERFACE MTI
WHERE
TRANSACTION_HEADER_ID=''; ---(From Transaction Open Interface)
WHERE
TRANSACTION_HEADER_ID=''; ---(From Transaction Open Interface)