Project

General

Profile

Bug #1454

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

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
03/06/2023
Due date:
% Done:

0%

Estimated time:
ASS_INVENT.txt (45.7 KB) ASS_INVENT.txt Luc Tran Van, 03/06/2023 09:57 AM

History

#2 Updated by Luc Tran Van over 2 years ago

INSERT INTO TR_REQ_CAR_FUEL (FUEL_ID, REFUEL_DATE, NUMBER_LITERS, REQ_ID, NOTES, AMOUNT, TOTAL_AMOUNT)
VALUES ('', GETDATE, 60, '', N'', 21727.27, 0);

ALTER TABLE TR_REQ_CAR_FUEL
ALTER COLUMN AMOUNT DECIMAL;
ALTER COLUMN TOTAL_AMOUNT DECIMAL;

#3 Updated by Luc Tran Van over 2 years ago

DECLARE @l_FUEL_ID VARCHAR
EXEC SYS_CodeMasters_Gen 'TR_REQ_CAR_FUEL', @l_FUEL_ID out

#4 Updated by Luc Tran Van about 2 years ago

SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID =(
SELECT trjf.REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_CODE='AFT-23-000189')

Also available in: Atom PDF