TTCT 0018.txt
| 1 |
UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='PLT000000076879',PLAN_ID='PLM000000017922',GOODS_ID='GOO000001061915' WHERE REQ_ID='PLRD00000200708' |
|---|---|
| 2 |
UPDATE dbo.PL_REQUEST_TRANSFER SET TO_TRADE_ID='PLT000000076879',TO_PLAN_ID='PLM000000017922',TO_GOOD_ID='GOO000001061915' WHERE REQ_DOC_ID='PLRD00000200708' |
| 3 |
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID =8382 |
| 4 |
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TC' WHERE REQ_ID='PLRD00000200708' |
| 5 |
UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='PTGDK_TT' WHERE ID=8383 |
| 6 |
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=8381 |
| 7 |
|
| 8 |
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'PLRD00000200708',N'GDK_TT',N'U',N'GDK',N'',N'',NULL,N'TC',N'N',N'',N'DM0000000000015',N'Chờ Giám đốc khối xác nhận',NULL,N'') |
| 9 |
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'PLRD00000200708',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 xác nhận',NULL,N'') |
| 10 |
|