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

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2024/000048')
UPDATE PL_REQUEST_PROCESS SET STATUS='P' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='P' WHERE REQ_ID =@REQ_ID AND TLNAME ='nguyennhk' AND TYPE_JOB ='XL'
SELECT * from PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_CODE = '000086/2023/TTr-P.HC-BP.MH'
--18012024_SECRETKEY

DECLARE @REQ_ID VARCHAR
SET @REQ_ID = (SELECT crt.REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE crt WHERE crt.REPORT_NO = '007420/2023/TTr-0690604')
UPDATE CM_APPROVE_GROUP SET APPROVE_DT = '12-12-2023' WHERE REQ_ID = @REQ_ID
SELECT * FROM CM_APPROVE_GROUP cag WHERE cag.REQ_ID = @REQ_ID

SELECT * FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000333/2023TTr-0690504'