1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
SELECT t7846.x_tp_veh_name AS c2,
t7846.x_tp_cbu_name AS c3,
t7846.x_tp_vfv_fit_set_name AS c4,
t7337.x_tp_export_flg AS c5,
t7337.x_tp_sal_loc AS c6,
t9875.dataset AS c7,
t7518.x_tp_exp_vfv_wid AS c9,
t7518.dataset AS c10,
t7337.x_tp_market_rate AS c11,
t7518.x_tp_vfv_qty AS c12
FROM ((SELECT row_id dataset,
x_tp_start_year,
x_tp_end_year
FROM wx_plan_d
WHERE x_tp_error = 'Plan succesfully created'
UNION ALL
SELECT 'Live Data' dataset,
TO_NUMBER (NULL) x_tp_start_year,
TO_NUMBER (NULL) x_tp_end_year
FROM DUAL)) t9875,
wx_plan_exp_d t7337,
wx_plan_veh_f t7518,
wx_plan_veh_d t7846,
wx_plan_seg_d t7454
WHERE ( t7337.x_tp_vfv_wid = t7518.x_tp_veh_d_wid
AND t7337.dataset = t7518.dataset
AND t7518.dataset = t9875.dataset
AND t7518.x_tp_veh_d_wid = t7846.row_wid
AND t7518.dataset = t7846.dataset
AND t7454.x_tp_vfv_wid = t7846.row_wid
AND t7454.dataset = t7846.dataset
AND CASE
WHEN t7846.x_tp_zone = 'ALL' THEN 1
WHEN 'ALL' = 'ALL' THEN 1
WHEN t7846.x_tp_cbu_name IN ('BMW', 'NO_DATA') THEN 1
WHEN t7846.x_tp_zone_cbu IN ('BMW_TCAO', 'BMW_TCOA', 'BMW_TCOE', 'NO_DATA') THEN 1
WHEN t7846.x_tp_zone_cntry = 'NO_DATA' THEN 1
WHEN t7846.x_tp_cbu_cntry = 'NO_DATA' THEN 1
WHEN t7846.x_tp_zone_cbu_cntry = 'NO_DATA' THEN 1
ELSE 0
END = 1
AND t7846.x_tp_level = 'Fitted Version'
AND t7846.x_tp_veh_name = 'DSAN'
AND t7846.x_tp_cbu_name = 'HON'
AND t7518.dataset = 'Live Data'
AND t9875.dataset = 'Live Data'
) |
Partager