1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
select e.typemvt as _tmvt, e.datemvt as _date, e.numbon as _nbon, e.immvehic as _camion,
( case e.typemvt when '01' then de.quantite else 0 end ) as m_livraison,
( case e.typemvt when '02' then de.quantite else 0 end ) as m_retour,
( case e.typemvt when '03' then de.quantite else 0 end ) as m_cession,
c.nom as nom, c.clcleunik as Id_client,
de.emcleunik as Id_emb, ct.numcontrat as num,
eb.codeemb as num_emb
from encaisse e
inner join decaisse de
on ( e.encleunik = de.encleunik )
inner join contrat ct
on ( e.cocleunik = ct.cocleunik )
inner join client c
on ( ct.clcleunik = c.clcleunik )
inner join emballag eb
on ( de.emcleunik = eb.emcleunik )
where encaisse.cocleunik = Saisie_Contrat
order by eb.codeemb, e.typemvt, e.datemvt, e.numbon |
Partager