1 2 3 4 5 6
| SELECT dbo_API_PROCESS_GESTION.LIB_TYPE_GESTION, dbo_API_PROCESS_GESTION.LIB_SOUS_PROCESS, TR_TX_ROTATION.PERIODE, TR_TX_ROTATION.ID_PTF_CDCAM, TR_TX_ROTATION.NM_PTF, TR_TX_ROTATION.CD_FORME_JUR, TR_TX_ROTATION.CD_CLASSIF_COB, TR_TX_ROTATION.ID_DEV_PTF, TR_TX_ROTATION.DT_PER_DEB, TR_TX_ROTATION.DT_PER_FIN, Round(TR_TX_ROTATION.ACHAT/1000,0) AS ACHAT, TR_TX_ROTATION.NB_LIGNE_ACHAT, Round(TR_TX_ROTATION.VENTE/1000,0) AS VENTE, TR_TX_ROTATION.NB_LIGNE_VENTE, Round(TR_TX_ROTATION.RACHAT/1000,0) AS RACHAT, Round(TR_TX_ROTATION.SOUSCR/1000,0) AS SOUSCR, Round(TR_TX_ROTATION.AM_AN_MOY/1000,0) AS AM_AN_MOY, TR_TX_ROTATION.TX_ROTATION
FROM ((dbo_API_PTF_AGENTS INNER JOIN dbo_API_PROCESS_GESTION ON dbo_API_PTF_AGENTS.CD_SOUS_PROCESS = dbo_API_PROCESS_GESTION.CD_SOUS_PROCESS) INNER JOIN TR_TX_ROTATION ON dbo_API_PTF_AGENTS.ID_PTF_CDCAM = TR_TX_ROTATION.ID_PTF_CDCAM) INNER JOIN dbo_API_PTF ON dbo_API_PTF_AGENTS.ID_PTF_CDCAM = dbo_API_PTF.ID_PTF_CDCAM
WHERE (((dbo_API_PTF_AGENTS.DT_FIN) Is Null) AND ((dbo_API_PTF_AGENTS.ID_ROLE_AGT)=1) AND ((dbo_API_PTF.ID_TYPE_PTF)<>9) AND ((dbo_API_PTF.ID_PTF_CDCAM) Not Like "*DIV*"))
GROUP BY dbo_API_PROCESS_GESTION.LIB_TYPE_GESTION, dbo_API_PROCESS_GESTION.LIB_SOUS_PROCESS, TR_TX_ROTATION.PERIODE, TR_TX_ROTATION.ID_PTF_CDCAM, TR_TX_ROTATION.NM_PTF, TR_TX_ROTATION.CD_FORME_JUR, TR_TX_ROTATION.CD_CLASSIF_COB, TR_TX_ROTATION.ID_DEV_PTF, TR_TX_ROTATION.DT_PER_DEB, TR_TX_ROTATION.DT_PER_FIN, Round(TR_TX_ROTATION.ACHAT/1000,0), TR_TX_ROTATION.NB_LIGNE_ACHAT, Round(TR_TX_ROTATION.VENTE/1000,0), TR_TX_ROTATION.NB_LIGNE_VENTE, Round(TR_TX_ROTATION.RACHAT/1000,0), Round(TR_TX_ROTATION.SOUSCR/1000,0), Round(TR_TX_ROTATION.AM_AN_MOY/1000,0), TR_TX_ROTATION.TX_ROTATION
HAVING (((TR_TX_ROTATION.PERIODE)='Annualy'))
ORDER BY dbo_API_PROCESS_GESTION.LIB_TYPE_GESTION ASC, dbo_API_PROCESS_GESTION.LIB_SOUS_PROCESS ASC, TR_TX_ROTATION.TX_ROTATION DESC; |
Partager