Project

General

Profile

Bug #1423

VẬN HÀNH SAU GOLIVE NGÀY 19-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/19/2022
Due date:
% Done:

0%

Estimated time:
ASS_MASTER_XE.txt (108 Bytes) ASS_MASTER_XE.txt Luc Tran Van, 12/19/2022 10:45 AM
DATA_#1_191222.xlsx (11.6 KB) DATA_#1_191222.xlsx Luc Tran Van, 12/19/2022 10:50 AM
MW_TRANS_KT_UPD.txt (10.7 KB) MW_TRANS_KT_UPD.txt Luc Tran Van, 12/19/2022 11:29 AM
DATA_BAO_191222.xlsx (12.1 KB) DATA_BAO_191222.xlsx Luc Tran Van, 12/19/2022 02:43 PM
DATA_#5_191222.xlsx (10.8 KB) DATA_#5_191222.xlsx Luc Tran Van, 12/19/2022 03:15 PM
PushCoreMW_201222.txt (771 Bytes) PushCoreMW_201222.txt Luc Tran Van, 12/20/2022 11:47 AM
PushCoreMW_201222.txt (1.32 KB) PushCoreMW_201222.txt Luc Tran Van, 12/20/2022 11:48 AM
DATA_#9.xlsx (12.4 KB) DATA_#9.xlsx Luc Tran Van, 12/20/2022 01:50 PM
rpt_TR_REQUEST_DOC_DT_ById.txt (19.2 KB) rpt_TR_REQUEST_DOC_DT_ById.txt Luc Tran Van, 12/20/2022 02:14 PM
rpt_TR_REQUEST_DOC_DT_ById.txt (19.2 KB) rpt_TR_REQUEST_DOC_DT_ById.txt Luc Tran Van, 12/20/2022 02:38 PM
DATA_#14.xlsx (12.1 KB) DATA_#14.xlsx Luc Tran Van, 12/20/2022 03:27 PM
DATA_#13.xlsx (12.8 KB) DATA_#13.xlsx Luc Tran Van, 12/20/2022 03:27 PM
DATA_#16.xlsx (12.3 KB) DATA_#16.xlsx Luc Tran Van, 12/20/2022 04:45 PM
DATA_#18.xlsx (10.2 KB) DATA_#18.xlsx Luc Tran Van, 12/20/2022 05:05 PM

History

#5 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID ='PLRD00000205413'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00000205413'

#9 Updated by Luc Tran Van over 2 years ago

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

#13 Updated by Luc Tran Van over 2 years ago

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

#14 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE = '0379/2022/TTr-0690604'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE = '0379/2022/TTr-0690604')

#16 Updated by Luc Tran Van over 2 years ago

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

#18 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003192')

Also available in: Atom PDF