Project

General

Profile

Support #674

Cập nhật lùi ngày cho tờ trình số 0002 0240005

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

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

0%

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0240005'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200405'
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='10/9/2020 12:00:00 AM' WHERE REQ_ID ='PLRD00000200405'
UPDATE PL_REQUEST_DOC WHERE SET APPROVE_DT ='10/9/2020 12:00:00 AM' REQ_CODE ='0002/2020/TTr-0240005'

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0240005'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200405'
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='10/9/2020 12:00:00 AM' WHERE REQ_ID ='PLRD00000200405'
UPDATE PL_REQUEST_DOC SET APPROVE_DT ='10/9/2020 12:00:00 AM' WHERE REQ_CODE ='0002/2020/TTr-0240005'

SELECT * FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000200405'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251459'
SELECT * FROM CM_HANGHOA WHERE HH_ID ='HH0000001058863'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000200405'
EXEC RPT_TR_REQUEST_DOC_DT_BYID 'TRRD00000251459'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF