Project

General

Profile

Bug #197

PYCMS số PUR/2020/000083, sau khi DVCM phê duyệt phiếu đang lên GĐK (Phiếu này dưới 5 triệu nên không đi qua GDK)

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

Status:
Closed
Priority:
Normal
Assignee:
Start date:
09/18/2020
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000083'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251083'

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID ='TRRD00000251083'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C', PARENT_PROCESS_ID ='DMMS' WHERE REQ_ID ='TRRD00000251083' AND ID ='2330'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251083' AND ID ='2329'

EXEC TR_REQ_DOC_INS_TO_PO 'TRRD00000251083'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF