Support #885
Cập nhật ngày lùi PUR 2020 834
Start date:
02/03/2021
Due date:
% Done:
0%
Estimated time:
Description
DECLARE @REQ_ID VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000834')
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT='2020-12-21' WHERE REQ_ID =@REQ_ID AND PROCESS_ID <>'APPROVE'
UPDATE PL_PROCESS SET APPROVE_DT ='2020-12-21' WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET APPROVE_DT ='2020-12-21',REQ_DT ='2020-12-21' WHERE REQ_ID =@REQ_ID
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed