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_HISTORIA_NAJNOWSZA | Next Materialized View |
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 ) |