Support #771
Đưa PUR 1018 từ CN Quảng Ninh về HO tự mua sắm
Start date:
12/29/2020
Due date:
% Done:
0%
Estimated time:
Description
DECLARE @REQ_ID VARCHAR, @BRANCH_CREATE VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/001018')
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/001018')
UPDATE TR_REQUEST_DOC SET DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =@BRANCH_CREATE), BRANCH_DVMS = @BRANCH_CREATE WHERE REQ_CODE ='PUR/2020/001018' AND REQ_ID =@REQ_ID
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed