Project

General

Profile

Support #483

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

Added by Luc Tran Van almost 5 years ago. Updated almost 5 years ago.

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

0%

Estimated time:
PUR 235.xlsx (24.1 KB) PUR 235.xlsx Luc Tran Van, 10/19/2020 11:38 AM

History

#1 Updated by Luc Tran Van almost 5 years ago

  • File PUR 235.xlsx PUR 235.xlsx added
  • Subject changed from Xóa DVCM Kế Toán khỏi PYCMS PUR/2020/0002355 to Xóa DVCM Kế Toán khỏi PYCMS PUR/2020/000235

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

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

#2 Updated by Luc Tran Van almost 5 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4314'

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

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000001078'

#3 Updated by Luc Tran Van almost 5 years ago

  • Status changed from New to Closed

Also available in: Atom PDF