Project

General

Profile

Support #485

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

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/000230'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000230' )

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

PUR 230.xlsx (24.4 KB) PUR 230.xlsx Luc Tran Van, 10/19/2020 11:49 AM

History

#2 Updated by Luc Tran Van over 4 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4317'

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

DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000001079'

#3 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF