27122020- FILE 1- CAP NHAT TO TRINH CHU TRUONG GIAY.txt
| 1 |
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_CODE ='PUR/2020/000463' |
|---|---|
| 2 |
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_CODE ='PUR/2020/000572' |
| 3 |
DECLARE @REQ_ID VARCHAR(15), @BRANCH_CREATE VARCHAR(15) |
| 4 |
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000630 ') |
| 5 |
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000630') |
| 6 |
UPDATE TR_REQUEST_DOC SET DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =@BRANCH_CREATE), BRANCH_DVMS = @BRANCH_CREATE WHERE REQ_CODE ='PUR/2020/000630' AND REQ_ID =@REQ_ID |
| 7 |
-- CAP NHAT HOAN TAT CHU TRUONG |
| 8 |
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE', AUTH_STATUS ='A', REQ_CODE ='911/2020/TTr-P.TT&TH', REQ_DT ='2020-11-13', EFFEC_DT = '2020-11-13' WHERE REQ_CODE ='0055/2020/TTr-0690405' |