Project

General

Profile

Support #463

Xóa ĐVCM Kế Toán khỏi PYCMS - PUR 2020 000194

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

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
10/14/2020
Due date:
% Done:

0%

Estimated time:
DATA PUR 2020 000194.xlsx (23.4 KB) DATA PUR 2020 000194.xlsx Luc Tran Van, 10/14/2020 02:24 PM
DATA PUR 2020 000194 - SAU KHI CAP NHAT.xlsx (33.3 KB) DATA PUR 2020 000194 - SAU KHI CAP NHAT.xlsx Luc Tran Van, 10/14/2020 02:27 PM

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000194'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251194'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251194'

#2 Updated by Luc Tran Van over 4 years ago

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251194'
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251194' AND ID ='3607'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID ='TRRD00000251194' AND ID ='3608'
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='GDK_PYC' WHERE REQ_CODE ='PUR/2020/000194'

#4 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF