Project

General

Profile

Feature #1422

VẬN HÀNH SAU GOLIVE NGÀY 16-12-2022

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/16/2022
Due date:
% Done:

0%

Estimated time:
1.0 PL REQUEST DOC TRANSFER DT BYID.txt (17.7 KB) 1.0 PL REQUEST DOC TRANSFER DT BYID.txt Luc Tran Van, 12/16/2022 11:28 AM
DATA_#1_161222.xlsx (12.2 KB) DATA_#1_161222.xlsx Luc Tran Van, 12/16/2022 11:36 AM
DATA_#4_161222.xlsx (23.4 KB) DATA_#4_161222.xlsx Luc Tran Van, 12/16/2022 11:50 AM
DATA_MW_TRANS_DT.txt (41.9 KB) DATA_MW_TRANS_DT.txt Luc Tran Van, 12/19/2022 09:33 AM
DATA_MW_ENTRIES_POST_191222.txt (58.1 KB) DATA_MW_ENTRIES_POST_191222.txt Luc Tran Van, 12/19/2022 09:49 AM
Fix lỗi tên tài khoản NCC.txt (409 Bytes) Fix lỗi tên tài khoản NCC.txt Luc Tran Van, 12/19/2022 09:50 AM
MW_ENTRIES_POST_CoreByRef_201222.txt (2.17 KB) MW_ENTRIES_POST_CoreByRef_201222.txt Luc Tran Van, 12/20/2022 10:19 AM

History

#1 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002380')

#4 Updated by Luc Tran Van over 2 years ago

0024/2022/TTDC-0110005

#6 Updated by Luc Tran Van over 2 years ago

EXEC PL_REQ_DOC_UPDATE_AFTER_APPROVE 'PLRD00000205751'

#10 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003167')

Also available in: Atom PDF