DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

----------XÓA PL_REQUEST_PROCESS WHERE PROCESS_ID = DVCM-------

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID = 'TRRD00000257294' AND PROCESS_ID = 'DVCM'

--------XÓA LỊCH SỬ ĐIỀU PHỐI PROCESS_ID DVCM---------

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = 'TRRD00000257294' AND PROCESS_ID = 84120

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = 'TRRD00000257294' AND PROCESS_ID = 84121

---------XÓA DVCM TRONG TR_REQUEST_COSTCENTER------

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = 'TRRD00000257294'

----------UPDATE TRẠNG THÁI PHIẾU THÀNH BƯỚC KẾ TIẾP---------------

UPDATE PL_REQUEST_PROCESS SET STATUS = 'C', PARENT_PROCESS_ID = 'DMMS' 

WHERE REQ_ID = 'TRRD00000257294' AND PROCESS_ID = 'GDK_PYC'

--------UPDATE PYCMS SANG BƯỚC KẾ TIẾP--------------

UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'GDK_PYC' WHERE REQ_ID = 'TRRD00000257294'