Update Reason codes that have been entered Incorrectly

Find the transaction either with the Trans_num or Item and date of the transaction with query similar to below.

select * from matltran_mst

where trans_num = '659219'

select * from reason_mst

update matltran_mst

set reason_code = 'WA'  -- correct reason code

where trans_num = '659219'