Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Materialized View | Materialized View MV_ZAPLATY_KLAS_HIST_NAJNOWSZA | Next Materialized View |
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 ) |