Materialized View MV_ZAPLATY_HISTORIA_NAJNOWSZA
Table Query
MV_ZAPLATY_HISTORIA_NAJNOWSZA
select ID,
        KWOTA,
        DATA_MOD,
        OPERATOR,
        B_ID_WPL,
        K_ID_WPL,
        ID_FAK,
        data_hist DATA_DO,
        TYP_DOK,
        K_OBR,
        R_OBR,
        ANULOWANA,
        NR_KONTR,
        ID_DZIELNICY,
        ID_RK_WB,
        recznie,
        data_dok,
        data_zap,
        ID_HIST
      from zaplaty_historia
      where id_hist in
        (
          select id_wiersza
          from
          (
            select zh.id_hist as id_wiersza,
              rank() over (partition by zh.b_id_wpl, zh.k_id_wpl order by zh.data_hist desc) ranking
            from
              zaplaty_historia zh
            where zh.data_hist <= trunc(sysdate)
          )
          where ranking = 1
        )