1 2 3 4 5 6 7 8 9 10 11 12 13
| SUM(CASE WHEN SYSDATE < to_date(DECVM,'YYYYMMDD') THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "NON ECHU",
SUM(CASE WHEN SYSDATE BETWEEN to_date(DECVM,'YYYYMMDD') + 00 AND to_date(DECVM,'YYYYMMDD') + 10 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "A_0_10_jours",
SUM(CASE WHEN SYSDATE BETWEEN to_date(DECVM,'YYYYMMDD') + 11 AND to_date(DECVM,'YYYYMMDD') + 20 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "A_11_20_jours",
SUM(CASE WHEN SYSDATE BETWEEN to_date(DECVM,'YYYYMMDD') + 21 AND to_date(DECVM,'YYYYMMDD') + 30 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "A_21_30_jours",
SUM(CASE WHEN SYSDATE BETWEEN to_date(DECVM,'YYYYMMDD') + 31 AND to_date(DECVM,'YYYYMMDD') + 40 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "A_31_40_jours",
SUM(CASE WHEN SYSDATE BETWEEN to_date(DECVM,'YYYYMMDD') + 41 AND to_date(DECVM,'YYYYMMDD') + 50 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "A_41_50_jours",
SUM(CASE WHEN SYSDATE > to_date(DECVM,'YYYYMMDD') + 51 THEN DECODE(INDCMV,'D',MTVMV,-MTVMV) ELSE 0 END) AS "SUP_51_jours" |
Partager