Paste code

SELECT ZZ.* 
    FROM (
        SELECT periodo_campania, num_ruc, producto, subproducto, tipo_carga,
               CASE WHEN producto in (&#039;NUEVOS APPAS&#039;, &#039;NUEVOS APCONSUMO&#039;, &#039;NUEVOS AP&#039;, &#039;NUEVOS AP SUPER_AGIL&#039;) THEN &#039;NUEVOS AP&#039;
                    WHEN producto in (&#039;ECOSISTEMAS&#039;) OR subproducto LIKE &#039;%ECOSISTEMAS%&#039; THEN &#039;NUEVOS AP&#039;
                    WHEN producto in (&#039;NUEVOS PRE&#039;) then &#039;NUEVOS PRE&#039;
                    ELSE &#039;X&#039; END campania,
               CASE WHEN producto in (&#039;NUEVOS APPAS&#039;, &#039;NUEVOS APCONSUMO&#039;, &#039;NUEVOS AP&#039;, &#039;NUEVOS AP SUPER_AGIL&#039;) THEN &#039;NUEVOS AP&#039;
                    WHEN producto in (&#039;ECOSISTEMAS&#039;) OR subproducto LIKE &#039;%ECOSISTEMAS%&#039; THEN &#039;ECOSISTEMAS&#039;
                    WHEN producto in (&#039;NUEVOS PRE&#039;) then &#039;NUEVOS PRE&#039;
                    ELSE &#039;X&#039; END campanha,
               CAST((
                   CASE WHEN oferta like &#039;%Venta%&#039; then Null 
                        WHEN LENGTH(split_part(oferta, &#039;Oferta 2: &#039;, 2)) > 0 then split_part(oferta, &#039;Oferta 2: &#039;, 2) 
                        WHEN LENGTH(split_part(oferta, &#039;Oferta 2:&#039;, 2)) > 0 then split_part(oferta, &#039;Oferta 2:&#039;, 2) 
                        WHEN LENGTH(split_part(oferta, &#039;/&#039;, 2)) > 0 then split_part(oferta, &#039;/&#039;, 2) 
                   ELSE oferta end) AS DOUBLE) oferta,
               plazo,
               bucket,
               canal_tlv,
               tasa,
               CASE WHEN tasa_piso is null and tasa is not null then tasa -0.02 else tasa_piso end tasa_piso,
               ROW_NUMBER() OVER(PARTITION BY periodo_campania, num_ruc, producto ORDER BY tasa DESC) orden_campania,
               periodo_campania p_periodo
        FROM d_mdl_vpc_disc.HM_DESPLIEGUE_CAMPANIAS 
        WHERE producto in (&#039;NUEVOS PRE&#039;, &#039;ECOSISTEMAS&#039;, &#039;NUEVOS APPAS&#039;, &#039;NUEVOS APCONSUMO&#039;, &#039;NUEVOS AP&#039;, &#039;NUEVOS AP SUPER_AGIL&#039;)
        and periodo_campania is not null
        and periodo_campania not like &#039;&#039;
        and num_ruc is not null
        and num_ruc not like &#039;&#039;
     ) ZZ
     WHERE ZZ.orden_campania = 1