Project

General

Profile

Support #787

Đưa PUR 1000 về CN Thăng Long tự mua sắm

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/30/2020
Due date:
% Done:

0%

Estimated time:

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR, @BRANCH_CREATE VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/001000')
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/001000')
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/001000' AND REQ_ID =@REQ_ID

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF