SELECT
                                    T20781.TYPE_THEME as c4,
                                    T20781.THEME as c5,
                                    T20781.ORDRE_AFFICHAGE as c6,
                                    T20781.IDTHEME_PRODUIT as c7,
                                    T20765.IDPERIODE_MOIS as c8,
                                    T20765.LIBELLE_PERIODE as c9,
                                    T20807.UNITE_VOL_MN as c10,
                                    T20621.QTE as c19,
                                    case T20621.UNITE_VOL when 'u' then T20621.VOLUME when 'UNITE' then T20621.VOLUME when 'unité' then T20621.VOLUME when 'Unite' then T20621.VOLUME when 'NBR' then T20621.VOLUME when 'NB' then T20621.VOLUME when 'F' then T20621.VOLUME when 'euros' then T20621.VOLUME when 'sms' then T20621.VOLUME when 'SMS' then T20621.VOLUME when 'ko' then T20621.VOLUME when 'KO' then T20621.VOLUME when 'mo' then T20621.VOLUME * 1024 when 'MO' then T20621.VOLUME * 1024 when 'meg' then T20621.VOLUME * 1024 when 'MEG' then T20621.VOLUME * 1024 when 's' then T20621.VOLUME / nullif( 60.0, 0) when 'S' then T20621.VOLUME / nullif( 60.0, 0) when 'sec' then T20621.VOLUME / nullif( 60.0, 0) when 'h' then T20621.VOLUME * 60 when 'H' then T20621.VOLUME * 60 when 'mn' then T20621.VOLUME when 'MN' then T20621.VOLUME else T20621.VOLUME / nullif( 60.0, 0) end  as c20,
                                    T20621.MONTANT as c21
                              FROM  facturation T20621,
                                    produit T20781,
                                    PERIODE T20765,
                                    UNITE_VOLUME T20807,
                                    ORGAOPERATEUR T20692,
                                    (
                                    select o.idracine,o.idperiode_mois , o.idsous_tete, c.type_orga, o.a,o.b, o.c,o.d,o.e,o.f,o.g,o.h,o.i,o.j
                                    FROM test2_orgaclient o, cliche c
                                    WHERE o.idracine=4875597
                                          --and  o.A = CAST(4875597 AS INTEGER)
                                          and o.idcliche = c.idcliche
                                          and o.b = c.idorganisation
                                    ) T129566
                              WHERE T20621.idperiode_mois BETWEEN 141 - 5 and 141
                                    AND T20621.idracine_master=4875597
                                    AND T20621.idsous_tete=2573071
                                    and T20621.IDPRODUIT_CATALOGUE = T20781.IDPRODUIT_CATALOGUE
                                    and T20781.IDPROFIL_ANALYSE = 1.0
                                    and T20781.LANGUE_PAYS = substr('fr_FR' , 1 , 2)
                                    AND T20621.IDPERIODE_MOIS = T20765.IDPERIODE_MOIS
                                    AND T20765.LANGUE_PAYS = 'fr_FR'
                                    and T20621.UNITE_VOL = T20807.UNITE_VOL
                                    and T20621.IDSOUS_COMPTE = T20692.IDSOUS_COMPTE
                                    and T20621.IDSOUS_TETE = T20692.IDSOUS_TETE
                                    AND T20692.IDSOUS_TETE=2573071
                                    AND T20692.idracine=4875597
                                    and T129566.IDRACINE = 4875597
                                    and T129566.B = 4875597
                                    and T20621.IDPERIODE_MOIS = T129566.IDPERIODE_MOIS
                                    and T20621.IDSOUS_TETE = T20692.IDSOUS_TETE
                                    and T129566.IDSOUS_TETE = 2573071
                                    and decode(cast(4875597 as  INTEGER  ), 0, cast(4875597 as  INTEGER  ), cast(4875597 as  INTEGER  )) = decode('A','C', T129566.C, 'D', T129566.D, 'E', T129566.E, 'F', T129566.F, 'G', T129566.G, 'H', T129566.H, 'I', T129566.I, 'J', T129566.J, 'IDSOUS_TETE', T129566.IDSOUS_TETE, T129566.B) and (T129566.TYPE_ORGA in ('ANU', 'CUS', 'GEO', 'INT', 'RAC', 'SAV'))