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
|
SELECT to_date(substr(qvs.date_create,1,8),'YYYY/MM/DD') as date1,
qcl.short_text1,
dcf.price,
to_char( to_date(to_date(substr(qvs.date_create,1,8),'YYYY/MM/DD'),'DD/MM/YYYY'), 'WW') as date2,
dcf.idcart
FROM (SELECT idcart, linequote, price, dateoffer
FROM ...
) dcf,
(SELECT id_entity, short_text1
FROM ...
WHERE id_class = 'quoUps'
AND num_array = 0
AND num_line = 0) qcl,
(SELECT date_create, id_quote
FROM ...
WHERE DESCR NOT LIKE '%test%'
AND FLAG_IS_ACTIVE = 1
)qvs left outer join (SELECT z_id_cart
FROM ...
WHERE flag2 =1
AND id_item <> 'multi-produits'
AND id_item <> 'price List'
AND id_item <> 'simu'
)cla on cla.z_id_cart = qvs.id_quote,
(SELECT z_id_cart, num_line
FROM ...
WHERE flag2 =1
AND id_item <> 'multi-produits'
AND id_item <> 'price List'
AND id_item <> 'simu'
)cla
left outer join (SELECT idcart
FROM ...
) dcf on dcf.idcart = cla.z_id_cart
left outer join (SELECT linequote
FROM ...
) dcf on dcf.linequote = cla.num_line
WHERE ... |
Partager