Nombre de documents diffusés sur une période donnée pour un fournisseur donné pour une ou toutes les références (tous types de commandes)

SELECT
STATS_DAY_DOC.PRIMARY_KEY AS REFERENCE,
STATS_DAY_DOC.NAME AS DOCUMENT,
STATS_COMMUN_SUPPLIER.NAME AS FOURNISSEUR,
SUM( STATS_ORDER_DOC.DOC_QUANTITY ) AS QUANTITE,
STATS_DAY_DOC.STOCK AS STOCK,
STATS_DAY_DOC.DOC_ACTIVE AS ACTIF,
STATS_DAY_DOC.DOC_PUBLISHED AS PUBLIE,
STATS_COMMUN_NATURE.NAME AS NATURE,
STATS_COMMUN_TARGET.NAME AS CIBLE,
STATS_DAY_DOC.DOC_COMMENTAIRE AS COMMENTAIRE


FROM
STATS_ORDER,
STATS_ORDER_DOC,
STATS_DAY_DOC


LEFT JOIN
STATS_COMMUN_SUPPLIER ON STATS_DAY_DOC.SUPPLIER_ID = STATS_COMMUN_SUPPLIER.SUPPLIER_ID

LEFT JOIN
STATS_COMMUN_NATURE ON STATS_DAY_DOC.NATURE_ID = STATS_COMMUN_NATURE.NATURE_ID

LEFT JOIN
STATS_COMMUN_TARGET ON STATS_DAY_DOC.CIBLE_ID = STATS_COMMUN_TARGET.TARGET_ID

WHERE
STATS_ORDER.ORDER_ID = STATS_ORDER_DOC.ORDER_ID
AND STATS_DAY_DOC.DOC_ID = STATS_ORDER_DOC.DOC_ID
AND STATS_DAY_DOC.SUPPLIER_ID = STATS_COMMUN_SUPPLIER.SUPPLIER_ID
AND TRANSLATE( LOWER( STATS_COMMUN_SUPPLIER.NAME ), 'àäâçéèëêìîïòöôùüû', 'aaaceeeeiiiooouuu' ) LIKE
CASE
WHEN ( '##supplier##' <> 'Aucun') THEN TRANSLATE( LOWER( '##supplier##' ), 'àäâçéèëêìîïòöôùüû', 'aaaceeeeiiiooouuu' )
ELSE TRANSLATE( LOWER( STATS_COMMUN_SUPPLIER.NAME ), 'àäâçéèëêìîïòöôùüû', 'aaaceeeeiiiooouuu' )
END
AND STATS_DAY_DOC.PRIMARY_KEY LIKE
CASE
WHEN ( '##ref##' IS NOT NULL ) THEN TO_NUMBER( '##ref##', '9999999999' )
ELSE STATS_DAY_DOC.PRIMARY_KEY
END
AND STATS_ORDER.ORDER_DATE > TO_DATE( '##from_date##', 'dd/mm/yyyy' )
AND STATS_ORDER.ORDER_DATE < ( TO_DATE( '##to_date##', 'dd/mm/yyyy' ) + 1 )

GROUP BY
STATS_DAY_DOC.PRIMARY_KEY,
STATS_DAY_DOC.NAME,
STATS_COMMUN_SUPPLIER.NAME,
STATS_DAY_DOC.STOCK,
STATS_DAY_DOC.DOC_ACTIVE,
STATS_DAY_DOC.DOC_PUBLISHED,
STATS_DAY_DOC.DOC_COMMENTAIRE,
STATS_COMMUN_NATURE.NAME,
STATS_COMMUN_TARGET.NAME



ORDER BY
DOCUMENT