Project

General

Profile

PYCMS bỏ DVCM theo TTCT.txt

Luc Tran Van, 11/09/2022 10:40 AM

 
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