1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
select a.c_dev_cr, a.sum(n_ca_dr), b.n_ttx_conv_euro
from
(SELECT RPAD(REC_FACTURE.C_DEV_DR,5) C_DEV_DR,
SUM(TO_CHAR(REC_FACTURE.N_CA_FACT_DR,'999999999999999D00')) N_CA_DR
FROM REC_FACTURE where c_ent='"&reqEnt&"'
GROUP BY RPAD(REC_FACTURE.C_DEV_DR,5)
UNION
SELECT RPAD(REC_COMMANDE.C_DEV_DR,5) C_DEV_DR,
SUM(TO_CHAR(REC_COMMANDE.N_CA_CDE_DR,'999999999999999D00')) N_CA_DR
FROM REC_COMMANDE where c_ent='"&reqEnt&"'
GROUP BY RPAD(REC_COMMANDE.C_DEV_DR,5)
UNION SELECT
RPAD(REC_EXPEDITION.C_DEV_DR,5) C_DEV_DR,
SUM(TO_CHAR(REC_EXPEDITION.N_CA_EXP_DR,'999999999999999D00')) N_CA_DR
FROM REC_EXPEDITION where c_ent='"&reqEnt&"'
GROUP BY RPAD(REC_EXPEDITION.C_DEV_DR,5)) a, ttx_carat b
where b.c_dev=a.c_dev_dr and b.d_modif=to_date(sysdate,'DD/MM/YYYY')
group by c_dev_dr |
Partager