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
| SELECT DISTINCT
c.cpt_bnstr,
a.cd_art,
a.des_art_a,
j.px_vte_unia_tf_lig,
(j.px_vte_unia_tf_lig*d.qte),
c.no_int_ord_fab,
d.qte,
c.qte_recu,
Sum(g.qte_mvt) AS 'Somme sur qte_mvt',
dateformat(c.dt_hre_recep,'DD/MM/YY'),
dateformat(d.dte_hre_fin_prev,'DD/MM/YY')
FROM
obi.art a,
obi.fo_bnstr b,
obi.fo_bnstr_lig c,
obi.ordfab d,
obi.proc_art e,
obi.cl f,
obi.art_mvtreel g,
obi.fo_br_lig h,
obi.fo_pxach i,
obi.tf_dte_lig j
WHERE
b.cpt_bnstr = c.cpt_bnstr
AND d.no_int_ord_fab = c.no_int_ord_fab
AND e.cd_proc = d.cd_proc
AND e.no_int_art = a.no_int_art
AND a.cd_cl = f.cd_cl
AND a.cd_art = h.cd_art
AND h.no_int_art_fo = i.no_int_art_fo
AND i.no_int_tf = j.no_int_tf
AND g.no_int_ord_fab = d.no_int_ord_fab
AND ((b.cd_fo='10718') AND (d.cd_etat_ordfab Between '0' And '1')
AND (i.cd_fo ='10718')
AND (g.qte_mvt<0))
GROUP BY c.cpt_bnstr, a.cd_art, a.des_art_a, c.no_int_ord_fab, d.qte, c.qte_recu, dateformat(c.dt_hre_recep,'DD/MM/YY'), dateformat(d.dte_hre_fin_prev,'DD/MM/YY'),j.px_vte_unia_tf_lig
ORDER BY dateformat(c.dt_hre_recep,'DD/MM/YY') |
Partager