PYCMS bỏ DVCM theo TTCT.txt
1 |
----------XÓA PL_REQUEST_PROCESS WHERE PROCESS_ID = DVCM------- |
---|---|
2 |
--DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID = AND PROCESS_ID = 'DVCM' |
3 |
|
4 |
---------XÓA DVCM TRONG TR_REQUEST_COSTCENTER------ |
5 |
--DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = |
6 |
|
7 |
----------UPDATE TRẠNG THÁI PHIẾU HOÀN TẤT--------------- |
8 |
--UPDATE PL_REQUEST_PROCESS SET STATUS = 'C', PARENT_PROCESS_ID = 'DMMS' |
9 |
--WHERE REQ_ID = AND PROCESS_ID = 'APPROVE' |
10 |
|
11 |
--------UPDATE PYCMS HOÀN TẤT-------------- |
12 |
--UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = |
13 |
|
14 |
---------CHẠY STORE PHÁT SINH PO------------ |
15 |
--EXEC TR_REQ_DOC_Ins_To_PO |