Materialized View MV_ZAPLATY_KLAS_HIST_NAJNOWSZA
Table Query
MV_ZAPLATY_KLAS_HIST_NAJNOWSZA
select ID,
        kwota,
        data_mod,
        operator,
        b_id_wpl,
        k_id_wpl,
        id_fak,
        kl_dzial,
        kl_rozdzial,
        kl_paragraf,
        kl_zadanie,
        kl_zrodlo,
        typ_dok,
        k_obr,
        r_obr,
        anulowana,
        nr_kontr,
        id_dzielnicy,
        id_rk_wb,
        data_hist as data_do,
        data_dok,
        data_zap,
        id_hist
      from zaplaty_klasyfikacja_historia
      where id_hist in
        (
          select id_wiersza
          from
          (
            select zkw.id_hist as id_wiersza,
              rank() over (partition by zkw.b_id_wpl, zkw.k_id_wpl order by zkw.data_hist desc) ranking
            from
              zaplaty_klasyfikacja_historia zkw
            where zkw.data_hist <= trunc(sysdate)
          )
          where ranking = 1
        )