UPDATE TR_REQUEST_DOC_DT SET TRAN_TYPE_ID ='TRN0000000003' WHERE REQ_DOC_ID ='TRRD00000251513' UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = BRANCH_CREATE, DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000742')) WHERE REQ_CODE ='PUR/2020/000742' UPDATE PL_TRADEDETAIL SET AMT_ETM = AMT_ETM -15000000 WHERE TRADE_ID ='PLT000001062955' UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-28' WHERE REQ_ID ='TRRD00000251341' UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-28' WHERE REQ_ID ='TRRD00000251341' UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251320' UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251320' UPDATE TR_REQUEST_DOC SET REQ_DT ='2020-10-09' WHERE REQ_CODE ='PUR/2020/000320' UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251597' UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251597' UPDATE TR_REQUEST_DOC SET REQ_DT ='2020-10-09' WHERE REQ_CODE ='PUR/2020/000597'