3 queries found for "TOU Data"
Get all from TOU Data
select *
from CI_TOU_DATA
uploaded by Nuno Rodrigues
Get specific TOU Data
select *
from CI_TOU_DATA
where
TOU_DATA_SET_ID = 'XXXX'
uploaded by Nuno Rodrigues
Get actual TOU Data values that's used during billing
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