Project

General

Profile

Support #929

Đưa phiếu đề nghị thanh toán (KSV duyệt nhầm) về trạng thái chờ KSV phê duyệt : 022021/001137

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
03/02/2021
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='022021/001137'
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID ='TRPY00000209922'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='C' WHERE REQ_ID ='TRPY00000209922' AND ID ='30526'
UPDATE TR_REQ_PAYMENT SET AUTH_STATUS_KT ='U' WHERE REQ_PAY_CODE ='022021/001137'

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='022021/001137'
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID ='TRPY00000209922'
SELECT * FROM PL_PROCESS WHERE REQ_ID ='TRPY00000209922'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='C' WHERE REQ_ID ='TRPY00000209922' AND ID ='30526'
UPDATE TR_REQ_PAYMENT SET AUTH_STATUS_KT ='U' WHERE REQ_PAY_CODE ='022021/001137'
DELETE FROM PL_PROCESS WHERE ID ='85939'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF