2.8 REMOVE HANG MUC 1.1 TY VND PUR 2021 000346.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000346') |
| 3 |
UPDATE TR_REQUEST_DOC SET TOTAL_AMT = TOTAL_AMT -1100000000 WHERE REQ_ID =@REQ_ID |
| 4 |
DELETE FROM TR_REQUEST_DOC_PL_DT WHERE REQPL_DT_ID ='TRPLD0000003041' |
| 5 |
DELETE FROM TR_REQUEST_DOC_DT WHERE REQDT_ID ='TRRDD0000257710' |