select distinct
td.tou_data_dttm,
first_value(td.tou_cd) over(partition by td.tou_data_dttm order by tds.set_dttm desc) tou_cd
from ci_tou_data_set tds, ci_tou_data td
where tds.tou_map_id = :TOU_MAP_ID
and td.tou_data_set_id = tds.tou_data_set_id
and td.tou_data_dttm > :CONSUMPTION_PERIOD_START_DTTM
and td.tou_data_dttm <= :CONSUMPTION_PERIOD_END_DTTM
and tds.set_dttm <= sysdate
uploaded by Pavel Shubin