6.4 CONFIG MUC 1 - 2 EMAIL MOI NHAT (TRIDQ).txt
| 1 |
UPDATE PL_REQUEST_DOC_DT SET TRADE_ID ='PLT000000255078',PLAN_ID ='PLM000000251968' WHERE REQDT_ID ='PLRDD0000214514' |
|---|---|
| 2 |
UPDATE PL_REQUEST_TRANSFER SET TO_TRADE_ID ='PLT000000255078', TO_PLAN_ID ='PLM000000251968' WHERE REQ_TRANSFER_ID ='PLRT00000203199' |
| 3 |
UPDATE PL_TRADEDETAIL SET AMT_RECEIVE_TF = ISNULL(AMT_RECEIVE_TF,0) + 2500000 WHERE TRADE_ID ='PLT000000255078' |
| 4 |
|
| 5 |
DELETE FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000201517' |
| 6 |
UPDATE PL_TRADEDETAIL SET AMT_TF = AMT_TF -3000000 WHERE TRADE_ID ='PLT000000270196' |
| 7 |
UPDATE PL_TRADEDETAIL SET AMT_ETM = AMT_ETM +3000000, AMT_TF =0 WHERE TRADE_ID ='PLT000000270942' |
| 8 |
UPDATE PL_REQUEST_DOC_DT SET REQDT_TYPE ='I' WHERE REQ_ID ='PLRD00000201517' |
| 9 |
UPDATE PL_TRADEDETAIL_HIST SET AMT_APP=27000000 WHERE TRADE_ID ='PLT000000270942' |