DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001620')
UPDATE TR_REQUEST_DOC_DT SET UNIT_NAME = N'Cái' WHERE REQ_DOC_ID =@REQ_ID

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690602' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690602'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690603' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690603'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690604' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690604'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690405' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690405'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690703' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690703'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690802' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690802'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692103' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692103'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692104' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692104'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='8990000'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='069040304' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='069040304'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='069040306' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='069040306'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690404' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690404'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690601' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690601'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690803' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690803'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690902' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690902'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690903' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690903'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690905' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690905'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690907' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0690907'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691004' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0691004'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691005' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0691005'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691006' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0691006'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692001' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692001'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692002' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692002'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692003' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692003'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692101' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692101'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692102' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692102'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692105' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692105'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692201' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692201'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692203' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692203'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692205' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='0692205'
UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='89900001' AND BRANCH_ID ='DV0001')
WHERE DVDM_CODE ='89900001'