Project

General

Profile

Support #481

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

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:

Description

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

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

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4024'

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

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000000995'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Luc Tran Van

Also available in: Atom PDF