----------XÓA PL_REQUEST_PROCESS WHERE PROCESS_ID = DVCM-------
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID = 'TRRD00000256815' 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 = 'TRRD00000256815' AND PROCESS_ID = 84107

---------XÓA DVCM TRONG TR_REQUEST_COSTCENTER------
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = 'TRRD00000256815'

----------UPDATE TRẠNG THÁI PHIẾU HOÀN TẤT---------------
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C', PARENT_PROCESS_ID = 'DMMS' 
WHERE REQ_ID = 'TRRD00000256815' AND PROCESS_ID = 'APPROVE'

--------UPDATE PYCMS HOÀN TẤT--------------
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = 'TRRD00000256815'

---------CHẠY STORE PHÁT SINH PO------------
EXEC TR_REQ_DOC_Ins_To_PO 'TRRD00000256815'