Project

General

Profile

Support #675

Cập nhật ĐMMS từ HO về đơn vị mua sắm - PUR 611

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

Status:
Closed
Priority:
Normal
Assignee:
Start date:
11/26/2020
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000611'
SELECT * FROM CM_DMMS WHERE BRANCH_ID ='BRN000000000817'

UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = BRANCH_CREATE, DMMS_ID ='DMMS00000000026' WHERE REQ_CODE ='PUR/2020/000611'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251630'
EXEC PL_PROCESS_CURRENT_SEARCH 'TRRD00000251611','LUCTV','PYCMS'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF