UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM -2499305600,AMT_RECEIVE_TF=AMT_RECEIVE_TF-179305600 WHERE TRADE_ID ='PLT000000071225' UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM -647000000,AMT_RECEIVE_TF=AMT_RECEIVE_TF-247000000 WHERE TRADE_ID ='PLT000000071365' UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM -230325000 WHERE TRADE_ID ='PLT000001012725' UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM -157000000 WHERE TRADE_ID ='PLT000001071905' UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM -85000000 WHERE TRADE_ID ='PLT000001071881' UPDATE PL_TRADEDETAIL SET AMT_TF=AMT_TF-247000000 WHERE TRADE_ID ='PLT000000071208' UPDATE PL_TRADEDETAIL SET AMT_TF=AMT_TF-179305600 WHERE TRADE_ID ='PLT000000071348' UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200578' 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(N'PLRD00000200578',N'GDK_TT',N'C',N'GDK',N'',N'',NULL,N'TC',N'N',N'',N'DM0000000000015',N'Chờ giám đốc khối phê duyệt',0,NULL) 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(N'PLRD00000200578',N'GDK_TT',N'C',N'GDK',N'',N'',NULL,N'TC',N'N',N'',N'DM0000000000018',N'Chờ giám đốc khối phê duyệt',0,NULL) 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(N'PLRD00000200578',N'PTGDK_TT',N'U',N'PTGD',N'',N'',NULL,N'GDK_TT',N'N',N'',N'DM0000000000015',N'Chờ Phó tổng giám đốc khối phê duyệt',0,NULL) 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(N'PLRD00000200578',N'PTGDK_TT',N'U',N'PTGD',N'',N'',NULL,N'GDK_TT',N'N',N'',N'DM0000000000017',N'Chờ Phó tổng giám đốc khối phê duyệt',0,NULL) 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(N'PLRD00000200578',N'TGD',N'U',N'TGD',N'',N'',NULL,N'PTGDK_TT',N'N',N'',N'',N'Chờ Tổng giám đốc phê duyệt',0,NULL) UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='TGD',STATUS='U' WHERE PROCESS_ID='APPROVE' AND REQ_ID='PLRD00000200578'