Project

General

Profile

Support #671

Cập nhật do sai sót người dùng - PUR sau khi được duyệt mới phát hiện sai nhà cung cấp PUR 165

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

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

0%

Estimated time:

History

#1 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000165')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID = @REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = @REQ_ID
UPDATE TR_REQUEST_DOC_DT SET SUP_ID ='CMS000000251383' WHERE REQ_DOC_ID = @REQ_ID
--SELECT * FROM CM_TRAN_TYPE
--EXEC TR_REQ_DOC_Ins_TO_PO 'TRRDI0001125770'
SELECT * FROM TR_PO_MASTER WHERE REQ_DOC_ID = @REQ_ID
UPDATE TR_PO_MASTER SET SUP_ID ='CMS000000251383' WHERE REQ_DOC_ID = @REQ_ID

#2 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000533')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID = @REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = @REQ_ID
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = @REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = @REQ_ID

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF