Project

General

Profile

Feature #1514

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 25.04.2024

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
04/25/2023
Due date:
% Done:

0%

Estimated time:
TR_REQ_PROCESS_CHILD_App.txt (38.7 KB) TR_REQ_PROCESS_CHILD_App.txt Luc Tran Van, 04/25/2023 01:37 PM
CM_REJECT_LOG_ByType_Ins.txt (38.5 KB) CM_REJECT_LOG_ByType_Ins.txt Luc Tran Van, 04/25/2023 01:37 PM
Lấy toàn bộ thông tin PYCMS.txt (2.63 KB) Lấy toàn bộ thông tin PYCMS.txt Luc Tran Van, 04/25/2023 03:48 PM
DATA_#1_250423.xlsx (11.4 KB) DATA_#1_250423.xlsx Luc Tran Van, 04/25/2023 03:53 PM
payment_kt_app.txt (20.7 KB) payment_kt_app.txt Luc Tran Van, 04/25/2023 04:26 PM
DATA_TTCT_0001_25042023.xlsx (22.8 KB) DATA_TTCT_0001_25042023.xlsx Luc Tran Van, 04/25/2023 04:29 PM
[ASS_INVENTORY_UNSTOCKED_Ins].txt (2.1 KB) [ASS_INVENTORY_UNSTOCKED_Ins].txt Luc Tran Van, 04/25/2023 04:38 PM
[ASS_INVENTORY_UNSTOCKED_Upd] .txt (2.27 KB) [ASS_INVENTORY_UNSTOCKED_Upd] .txt Luc Tran Van, 04/25/2023 04:38 PM
[ASS_INVENTORY_UNSTOCKED_Del].txt (663 Bytes) [ASS_INVENTORY_UNSTOCKED_Del].txt Luc Tran Van, 04/25/2023 04:38 PM
INHACHTOAN_MW_BanViet.docx (115 KB) INHACHTOAN_MW_BanViet.docx Luc Tran Van, 04/25/2023 05:06 PM
INHACHTOAN_PAY_BanViet.docx (105 KB) INHACHTOAN_PAY_BanViet.docx Luc Tran Van, 04/25/2023 05:06 PM
INHACHTOAN_BanViet.docx (103 KB) INHACHTOAN_BanViet.docx Luc Tran Van, 04/25/2023 05:06 PM
ASS_AMORT_Do.txt (14.6 KB) ASS_AMORT_Do.txt Luc Tran Van, 04/25/2023 05:31 PM
note.txt (25.9 KB) note.txt Luc Tran Van, 04/25/2023 05:34 PM
PYC-XE2023000857.txt (502 Bytes) PYC-XE2023000857.txt Luc Tran Van, 04/25/2023 05:39 PM
BOLECHCHAYKH.txt (342 Bytes) BOLECHCHAYKH.txt Luc Tran Van, 04/25/2023 05:41 PM
DATA_TTCT_0019.xlsx (25.8 KB) DATA_TTCT_0019.xlsx Luc Tran Van, 04/25/2023 06:06 PM

History

#5 Updated by Luc Tran Van about 2 years ago

UPDATE PL_REQUEST_PROCESS_CHILD SET TLNAME='phuongtln1' WHERE ID='179405'

#10 Updated by Luc Tran Van about 2 years ago

#11 Updated by Luc Tran Van about 2 years ago

DECLARE @ID VARCHAR, @ID_PYCCT VARCHAR
SET @ID=(SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE='PYC-XE/2023/000857')
SET @ID_PYCCT=(SELECT REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_ID=@ID_PYCCT)

DELETE TR_REQUEST_CAR WHERE REQ_ID=@ID
DELETE TR_REQUEST_CAR_DETAIL WHERE REQ_ID=@ID
DELETE TR_REQ_CAR_FUEL WHERE REQ_ID=@ID
DELETE TR_REQUEST_JOB_FORM WHERE REQ_ID=@ID_PYCCT
DELETE TR_REQUEST_JOB_DETAIL WHERE REQ_ID=@ID_PYCCT
DELETE TR_REQUEST_JOB_TRAIN WHERE REQ_ID=@ID_PYCCT

#14 Updated by Luc Tran Van about 2 years ago

SELECT count(*) FROM ASS_ENTRIES_POST aep WHERE aep.TRN_ID=''

Also available in: Atom PDF