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
| SELECT
F_ARTSTOCK.AR_Ref,
F_ARTICLE.AR_Design,
F_ARTICLE.FA_CodeFamille,
F_DEPOT.DE_Intitule,
F_ARTSTOCK.AS_QteMini,
F_ARTSTOCK.AS_QteSto,
(F_ARTSTOCK.AS_QteMini - F_ARTSTOCK.AS_QteSto) AS AS_QteTransfert,
SUM(COALESCE(F_DOCLIGNE.DL_Qte,0)) AS QteVendu
FROM F_ARTSTOCK
INNER JOIN F_ARTICLE ON F_ARTICLE.AR_Ref = F_ARTSTOCK.AR_REF
INNER JOIN F_DEPOT
ON F_DEPOT.DE_No = F_ARTSTOCK.DE_No
LEFT OUTER JOIN F_DOCLIGNE
ON (F_DOCLIGNE.Ar_Ref = F_ARTSTOCK.AR_Ref
AND F_DOCLIGNE.DE_No = F_ARTSTOCK.DE_No
and (F_DOCLIGNE.Do_Date = '06/10/2007')
AND (F_DOCLIGNE.DO_Type IN(3,6,7,30)
)
WHERE
(F_ARTSTOCK.AS_QteMini > F_ARTSTOCK.AS_QteSto) AND
(F_ARTSTOCK.DE_No = 1)
GROUP BY
F_ARTSTOCK.AR_Ref,
F_ARTICLE.AR_Design,
F_ARTICLE.FA_CodeFamille,
F_DEPOT.DE_Intitule,
F_ARTSTOCK.AS_QteMini,
F_ARTSTOCK.AS_QteSto |
Partager