Project

General

Profile

Bug #788

Lỗi DMMS bị rỗng PUR 1038

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/31/2020
Due date:
% Done:

0%

Estimated time:
30122020 - FILE 0 CẤU HÌNH TỜ TRÌNH PHÒNG HC.txt (965 Bytes) 30122020 - FILE 0 CẤU HÌNH TỜ TRÌNH PHÒNG HC.txt Luc Tran Van, 12/31/2020 09:37 AM

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/001038')
SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/001038')
UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000008', BRANCH_DVMS = @BRANCH_CREATE WHERE REQ_CODE ='PUR/2020/001038' AND REQ_ID =@REQ_ID

EXEC PL_PROCESS_CURRENT_SEARCH @REQ_ID,'luctv','PYCMS'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF