1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
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,
F_ARTICLE.AR_Stat01 AS Pathologie,
F_ARTICLE.AR_Stat03 AS CatQte,
F_ARTICLE.AR_Stat04 AS CatValeur,
F_FAMILLE.FA_Central AS Central
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
INNER JOIN F_FAMILLE ON F_FAMILLE.FA_CodeFamille = F_ARTICLE.FA_CodeFamille
WHERE
(F_ARTSTOCK.AS_QteMini > F_ARTSTOCK.AS_QteSto) AND
(F_ARTSTOCK.DE_No = 1) AND
(F_FAMILLE.FA_Central >= 'ACC%') AND
(F_FAMILLE.FA_Central <= 'ALL%')
ORDER BY F_FAMILLE.FA_Central |
Partager