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
| SELECT
REF_GE05_ASSO_H.CODE_TIERS,
REF_GE05_ASSO_H.NOM_TIERS,
decode(REF_GE99_AXES_4.LIBC,'N/R','Non renseigné',REF_GE99_AXES_4.LIBC),
Max( to_number(substr(DWH_GE05_MESURE.PERIODE_MESURE,1,4)) )
FROM
REF_GE05_ASSO_H,
REF_GE99_AXES REF_GE99_AXES_4,
DWH_GE05_MESURE
WHERE
( DWH_GE05_MESURE.MI_AXE_CODE4=REF_GE99_AXES_4.AXE_CODE AND REF_GE99_AXES_4.CODE=DWH_GE05_MESURE.MI_CODE4 )
AND ( DWH_GE05_MESURE.MI_CODE1=REF_GE05_ASSO_H.CODE_SIRET AND REF_GE05_ASSO_H.NUM_CAF=DWH_GE05_MESURE.MI_CODE2 )
AND ( REF_GE05_ASSO_H.META_DAT_SUP is null )
AND
(
DWH_GE05_MESURE.CODE_INDICATEUR IN ( 'OP_ARR_CPT_MOIS' )
AND
DWH_GE05_MESURE.UO IN ( '39000' )
AND
DWH_GE05_MESURE.MI_CODE5 <> '0'
AND
( SUBSTR(DWH_GE05_MESURE.CODE_INDICATEUR, 1, 3) = 'OP_' )
AND
( SUBSTR(DWH_GE05_MESURE.CODE_INDICATEUR, 1, 3) = 'OP_' )
)
GROUP BY
REF_GE05_ASSO_H.CODE_TIERS,
REF_GE05_ASSO_H.NOM_TIERS,
decode(REF_GE99_AXES_4.LIBC,'N/R','Non renseigné',REF_GE99_AXES_4.LIBC) |
Partager