DELETE FROM TR_REQUEST_DOC WHERE REQ_ID ='TRRD00000252244'
DELETE FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000252244'
DELETE FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID ='TRRD00000252244'

INSERT INTO PL_REQUEST_PROCESS (REQ_ID,PROCESS_ID,STATUS,ROLE_USER,BRANCH_ID,CHECKER_ID, APPROVE_DT,PARENT_PROCESS_ID, IS_LEAF, COST_ID,DVDM_ID,NOTES,IS_HAS_CHILD, DEP_ID)  
VALUES ('PLRD00000201104','GDK_TT','C','GDK','','',NULL,'KT','N',NULL,'DM0000000000015',N'Chờ Giám Đốc Khối Hỗ Trợ phê duyệt','0',NULL)

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_TT', AUTH_STATUS='U' WHERE REQ_CODE ='0005/2021/TTr-0660005'
UPDATE PL_REQUEST_PROCESS SET STATUS ='U', PARENT_PROCESS_ID ='GDK_TT' WHERE ID ='13810'
UPDATE PL_TRADEDETAIL SET AMT_EXE = AMT_EXE -249600000.00 WHERE TRADE_ID ='PLT000000262646'

SELECT * FROM ASS_MASTER WHERE ASSET_CODE IN ('001CC19020006190003','001CC19060506190001','001CC19060506190002','001CC19060506190003','001CC19060606190010','001CC19060606190011','001CC19060606190012','001CC19060606190013','001CC19060506190004','001CC19060506190005','001CC19060506190006','001CC19060506190007','001CC19020006190005','001CC13020506190003','001CC13020506190004','001CC13020506190005','001CC14040206190001','016CC19020007190001','004CC19050810190006','004CC19050810190007','004CC14030110190001','004CC14020210190003','004CC19060410190024','004CC19060410190025','004CC19060410190026','004CC19060410190027','004CC19060510190029','004CC19060510190030','004CC19060510190031','004CC19060510190032','004CC19060510190033','004CC19060510190034','004CC19060510190035','003CC19060407190029','003CC19060407190030','003CC19060407190031','003CC19060407190032','003CC19060407190033','003CC19060507190041','003CC19060507190042','003CC19060507190043','003CC19060507190044','003CC19060507190045','003CC19060507190046','003CC19060507190047','003CC19060507190048','014CC19060505190024','014CC19060505190025','014CC19060505190026','069CC14020105190001','069CC14020105190002','069CC14020105190003','069CC14020105190004')
SELECT * FROM ASS_AMORT_DT WHERE
ASSET_ID IN (SELECT ASSET_ID FROM ASS_MASTER WHERE ASSET_CODE IN ('001CC19020006190003','001CC19060506190001','001CC19060506190002','001CC19060506190003','001CC19060606190010','001CC19060606190011','001CC19060606190012','001CC19060606190013','001CC19060506190004','001CC19060506190005','001CC19060506190006','001CC19060506190007','001CC19020006190005','001CC13020506190003','001CC13020506190004','001CC13020506190005','001CC14040206190001','016CC19020007190001','004CC19050810190006','004CC19050810190007','004CC14030110190001','004CC14020210190003','004CC19060410190024','004CC19060410190025','004CC19060410190026','004CC19060410190027','004CC19060510190029','004CC19060510190030','004CC19060510190031','004CC19060510190032','004CC19060510190033','004CC19060510190034','004CC19060510190035','003CC19060407190029','003CC19060407190030','003CC19060407190031','003CC19060407190032','003CC19060407190033','003CC19060507190041','003CC19060507190042','003CC19060507190043','003CC19060507190044','003CC19060507190045','003CC19060507190046','003CC19060507190047','003CC19060507190048','014CC19060505190024','014CC19060505190025','014CC19060505190026','069CC14020105190001','069CC14020105190002','069CC14020105190003','069CC14020105190004'))
AND AMORT_ID IN (SELECT AMORT_ID FROM ASS_AMORT WHERE NOTES =N'Phân bổ kỳ 3/2021')