Project

General

Profile

Support #484

Xóa DVCM Kế Toán khỏi PYCMS PUR/2020/000042

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/19/2020
Due date:
% Done:

0%

Estimated time:
PUR 042.xlsx (24.4 KB) PUR 042.xlsx Luc Tran Van, 10/19/2020 11:40 AM

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000042'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000042' )

SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000042' )

#2 Updated by Luc Tran Van over 4 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4322'

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='4323'

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000001080'

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF