1 2 3 4 5 6 7 8 9 10 11 12 13
|
SELECT PTA.LIBELLE AS TYPE, T.LIBELLE AS NOM, PARAM_CATEGORIE_ACTIVITE.LIBELLE AS CATEGORIE, Null AS CHAMP_LIBRE_2, Null AS NIVEAU_HIERARCHIQUE, T.CHARGE AS BUDGET, T.CHARGE AS DUREE_NATIVE, Null AS SSP_COD_TARIF
FROM [SELECT A.ID_LOT AS ID_LOT, A.ID_TYPE_ACTIVITE AS ID_TYPE_ACTIVITE, A.ID_CATEGORIE_ACTIVITE AS ID_CATEGORIE_ACTIVITE, A.LIBELLE AS LIBELLE, A.CHARGE AS CHARGE, A.ORDRE AS ORDRE_1, IIF(A.ID_ACTIVITE <=16, 1, 999) AS ORDRE_2
FROM ACTIVITES AS A
UNION ALL
SELECT F.ID_LOT AS ID_LOT, F.ID_TYPE_ACTIVITE AS ID_TYPE_ACTIVITE, F.ID_CATEGORIE_ACTIVITE AS ID_CATEGORIE_ACTIVITE, F.LIB_FCT AS LIBELLE, F.CHARGE AS CHARGE, F.ID_FONCTIONNALITE AS ORDRE_1, F.ID_EXIGENCE + 1 AS ORDRE_2
FROM FONCTIONNALITE AS F
UNION ALL
SELECT E.ID_LOT AS ID_LOT, E.ID_TYPE_ACTIVITE AS ID_TYPE_ACTIVITE, E.ID_CATEGORIE_ACTIVITE AS ID_CATEGORIE_ACTIVITE, E.LIB_EXG AS LIBELLE, E.CHARGE AS CHARGE, 0 AS ORDRE_1, E.ID_EXIGENCE + 1 AS ORDRE_2
FROM EXIGENCES AS E
]. AS T, PARAM_TYPE_ACTIVITE AS PTA, PARAM_CATEGORIE_ACTIVITE
WHERE ((([T].[ID_LOT])=[ID LOT]))
ORDER BY T.ID_LOT, T.ORDRE_2, T.ORDRE_1; |
Partager