1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT F31122Z1.SZDOCO OFs, F3112.WLKITA CodeArticle,PDta.IMDSC1 LibelleArticle , Max(F3112.WLOPSQ) AS SEQ, F31122Z1.SZAN8 OPERATEUR, to_char ( to_date ( F31122Z1.SZEDDT +1900000 , 'YYYYDDD' )) DateDuMvt,
sum((F31122Z1.szsoqs)/1000) as Qté
FROM proddta.F31122Z1
inner join proddta.f3112 on (szdoco = wldoco) and (szopsq = wlopsq)
RIGHT JOIN (
SELECT F3112.WLDOCO, F4101.IMDSC1, Max(F3112.WLOPSQ) AS MaxDeWLOPSQ
FROM proddta.F3112 LEFT JOIN proddta.F4101 ON (F3112.WLKITA = F4101.IMAITM)
GROUP BY F3112.WLDOCO, F4101.IMDSC1) PDta ON (F31122Z1.SZOPSQ = PDta.MaxDeWLOPSQ) AND (F31122Z1.SZDOCO = PDta.WLDOCO)
GROUP BY F31122Z1.SZDOCO, F3112.WLKITA, F31122Z1.SZAN8, F31122Z1.SZEDDT, F31122Z1.sztyr, PDta.IMDSC1
HAVING (((Max(F3112.WLOPSQ))>10000 And (Max(F3112.WLOPSQ))<60000)) and (F31122Z1.SZEDDT = 119203) and (F31122Z1.sztyr ='4')
ORDER BY (Max(F3112.WLOPSQ)) asc, F3112.WLKITA desc
; |
Partager