Project

General

Profile

Support #556

PYCMS có DMMS trùng với DVCM nhưng khi DMMS phê duyệt thì hệ thống vẫn phải chờ DVCM --> Nếu đúng thì phải hoàn tất. PUR 276

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

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

0%

Estimated time:

Description

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000276'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251276'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251276'

PUR 276.xlsx (25.7 KB) PUR 276.xlsx Luc Tran Van, 10/29/2020 02:04 PM
PUR 276 SAU KHI CAP NHAT.xlsx (22.5 KB) PUR 276 SAU KHI CAP NHAT.xlsx Luc Tran Van, 10/29/2020 02:06 PM
PUR 272.xlsx (25.7 KB) PUR 272.xlsx Luc Tran Van, 10/29/2020 02:08 PM
PUR 272 SAU KHI CAP NHAT.xlsx (24.2 KB) PUR 272 SAU KHI CAP NHAT.xlsx Luc Tran Van, 10/29/2020 02:10 PM

History

#1 Updated by Luc Tran Van over 4 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='5420'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='5421'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='5422'
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_CODE ='PUR/2020/000276'
--EXEC TR_REQ_DOC_INS_TO_PO 'TRRD00000251276'

#3 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000272'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251272'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251272'

#4 Updated by Luc Tran Van over 4 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='5359'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='5360'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='5361'
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_CODE ='PUR/2020/000272'
--EXEC TR_REQ_DOC_INS_TO_PO 'TRRD00000251272'

#5 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF