UPDATE TR_REQUEST_DOC SET DMMS_ID=(SELECT DMMS_ID FROM CM_DMMS WHERE CM_DMMS.BRANCH_ID=TR_REQUEST_DOC.BRANCH_CREATE),BRANCH_DVMS=BRANCH_CREATE 
WHERE BRANCH_CREATE <> BRANCH_DVMS AND BRANCH_DVMS <>'DV0001' AND PROCESS_ID='DMMS'