Project

General

Profile

Support #524

Cập nhật các thông số về ngày duyệt, ngày gửi phê duyệt (Log) của tờ trình lùi ngày số 0002 0150005

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/26/2020
Due date:
% Done:

0%

Estimated time:

Description

1- Ngày gửi phê duyệt
2- Ngày duyệt các cấp trưởng phòng.

DATA TO TRINH 0002 0150005.xlsx (25.7 KB) DATA TO TRINH 0002 0150005.xlsx Luc Tran Van, 10/26/2020 11:11 AM
DATA TO TRINH 0002 0150005 - SAU KHI CAP NHAT TO TRINH LUI NGAY.xlsx (26.1 KB) DATA TO TRINH 0002 0150005 - SAU KHI CAP NHAT TO TRINH LUI NGAY.xlsx Luc Tran Van, 10/26/2020 11:24 AM

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0150005'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000200379'
SELECT * FROM PL_PROCESS WHERE REQ_ID ='PLRD00000200379'

#2 Updated by Luc Tran Van over 4 years ago

UPDATE PL_REQUEST_DOC SET EFFEC_DT = REQ_DT WHERE REQ_CODE ='0002/2020/TTr-0150005'
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='10/16/2020 1:33:59 PM' WHERE REQ_ID ='PLRD00000200379'

#3 Updated by Luc Tran Van over 4 years ago

UPDATE PL_REQUEST_DOC SET EFFEC_DT = REQ_DT WHERE REQ_CODE ='0002/2020/TTr-0150005'
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='10/16/2020 1:33:59 PM' WHERE REQ_ID ='PLRD00000200379'

#5 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF