Project

General

Profile

Support #482

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

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 238.xlsx (24.2 KB) PUR 238.xlsx Luc Tran Van, 10/19/2020 11:26 AM

History

#1 Updated by Luc Tran Van over 4 years ago

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

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

#2 Updated by Luc Tran Van over 4 years ago

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

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

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4289'

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

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000001045'

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF