Materialized View MV_PARAM_PARAMETRY_WSZYSTKIE
Table Query
MV_PARAM_PARAMETRY_WSZYSTKIE
SELECT id,
      ranking,
      nazwa_parametru,
      nazwa_obiektu,
      typ_obiektu,
      czy_okreslony_w_czasie,
      data_od,
      lead(data_od - interval '1' second) over(partition by id_sl_param_parametr order by data_od) AS data_do,
      wartosc_number,
      wartosc_varchar,
      wartosc_date
    FROM
      (SELECT
        spp.id                                                                AS id_sl_param_parametr,
        pw.id                                                                 AS id,
        rank() over (partition BY spp.id order by pw.data_od DESC, pw.id ASC) AS ranking,
        spp.nazwa                                                             AS nazwa_parametru,
        spo.nazwa                                                             AS nazwa_obiektu,
        spo.typ                                                               AS typ_obiektu,
        spp.czy_okreslony_w_czasie,
        nvl(pw.data_od, case spp.czy_okreslony_w_czasie when 'T' then utils.data_min end) AS data_od,
        NVL(pw.wartosc_number , spp.wartosc_number)   AS wartosc_number,
        NVL(pw.wartosc_varchar , spp.wartosc_varchar) AS wartosc_varchar,
        NVL(pw.wartosc_date , spp.wartosc_date)       AS wartosc_date
      FROM sl_param_parametry spp
      LEFT JOIN param_wartosci pw
      ON spp.id = pw.id_sl_param_parametr
      LEFT JOIN sl_param_obiekty spo
      ON spo.id = spp.id_sl_param_obiekt
      )