update mtl_transactions_interface
set process_flag = 1,
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;
update mtl_material_transactions_temp
set process_flag='Y',
LOCK_FLAG=NULL,
TRANSACTION_MODE=3,
ERROR_CODE=NULL,
ERROR_EXPLANATION_NULL
WHERE TRANSACTION_HEADER_ID = &TRANSACTION_HEADER_ID ;