Project

General

Profile

Feature #1546

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

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
06/29/2023
Due date:
% Done:

0%

Estimated time:
DATA_#3.xlsx (11.1 KB) DATA_#3.xlsx Luc Tran Van, 06/29/2023 03:09 PM
2.9.CAR_DRIVER_UPD.txt (6.93 KB) 2.9.CAR_DRIVER_UPD.txt Luc Tran Van, 06/29/2023 04:27 PM
3.0 CAR_DRIVER_INS.txt (7.49 KB) 3.0 CAR_DRIVER_INS.txt Luc Tran Van, 06/29/2023 04:28 PM
3.2.CAR DRIVER.txt (14.5 KB) 3.2.CAR DRIVER.txt Luc Tran Van, 06/29/2023 04:43 PM
DATA_#8.xlsx (9.82 KB) DATA_#8.xlsx Luc Tran Van, 06/29/2023 05:10 PM

History

#1 Updated by Luc Tran Van almost 2 years ago

SELECT ORIGINAL_FUEL_NUMBER, ORIGINAL_INDEX_NUMBER FROM CAR_MASTER WHERE N_PLATE ='79A-42505'
SELECT OLD_INDEX_NUMBER,NEW_INDEX_NUMBER,OLD_FUEL_NUMBER, NEW_FUEL_NUMBER FROM CAR_DRIVE WHERE CAR_ID =(SELECT CAR_ID FROM CAR_MASTER WHERE N_PLATE ='79A-42505') --29062023_SECRETKEY

#2 Updated by Luc Tran Van almost 2 years ago

DELETE FROM CAR_DRIVE WHERE CAR_ID =(SELECT CAR_ID FROM CAR_MASTER WHERE N_PLATE ='79A-42505') --29062023_SECRETKEY

#3 Updated by Luc Tran Van almost 2 years ago

SELECT * FROM PL_PROCESS pp WHERE pp.REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_CODE IN ('AFT-23-002062','AFT-23-001082','AFT-23-002237'))

#8 Updated by Luc Tran Van almost 2 years ago

SELECT * FROM TR_PO_MASTER tpm WHERE tpm.PO_CODE = 'PO069/23/0456'

#10 Updated by Luc Tran Van almost 2 years ago

DELETE FROM TR_PO_MASTER Where PO_ID='TRPM00000256795'
DELETE FROM TR_PO_PAYMENT WHERE PO_ID = 'TRPM00000256795'
DELETE FROM TR_PO_DETAIL WHERE PO_ID = 'TRPM00000256795'

Also available in: Atom PDF