DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

1.0 LẤY DATA
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/00009755'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRDI0001056103'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRDI0001056103'
2.0 SCRIPT XÓA

DECLARE @p_REQ_CODE VARCHAR, @p_REQ_ID VARCHAR
SET @p_REQ_CODE ='PUR/2020/00009755'
SET @p_REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = @p_REQ_CODE )
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@p_REQ_ID AND PROCESS_ID ='DVCM' AND ROLE_USER ='KSV'
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID =@p_REQ_ID AND REQ_COST_ID ='' -- TRUYEN COST ID VO
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID = @p_REQ_ID AND PROCESS_ID ='GDK_PYC' AND ROLE_USER ='GDK'