APPS.CSI_COUNTER_READINGS_PVT dependencies on OKC_TIME_CODE_UNITS_V

Line 3577: FROM OKC_TIME_CODE_UNITS_V

3573: AND pro.counter_property_id(+) = filt.counter_property_id;
3574: --
3575: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS
3576: SELECT uom_code
3577: FROM OKC_TIME_CODE_UNITS_V
3578: WHERE uom_code=p_filter_time_uom;
3579: --
3580: l_sqlstr_init VARCHAR2(2000);
3581: l_sqlstr VARCHAR2(2000);

Line 3704: from OKC_TIME_CODE_UNITS_V

3700: ELSIF ctrs.derive_function = 'AVERAGE' AND ctrs.filter_type = 'TIME' THEN
3701: Declare
3702: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS
3703: select uom_code
3704: from OKC_TIME_CODE_UNITS_V
3705: where uom_code=p_filter_time_uom;
3706: --
3707: CURSOR GET_FIRST_READING(d3_counter_id IN NUMBER) IS
3708: SELECT net_reading,value_timestamp