DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on OKC_TIME_CODE_UNITS_V

Line 3061: FROM OKC_TIME_CODE_UNITS_V

3057: AND pro.counter_property_id(+) = filt.counter_property_id;
3058: --
3059: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS
3060: SELECT uom_code
3061: FROM OKC_TIME_CODE_UNITS_V
3062: WHERE uom_code=p_filter_time_uom;
3063: --
3064: l_sqlstr_init VARCHAR2(2000);
3065: l_sqlstr VARCHAR2(2000);

Line 3177: from OKC_TIME_CODE_UNITS_V

3173: ELSIF ctrs.derive_function = 'AVERAGE' AND ctrs.filter_type = 'TIME' THEN
3174: Declare
3175: CURSOR GET_TIME_UOM_CUR(p_filter_time_uom IN VARCHAR2) IS
3176: select uom_code
3177: from OKC_TIME_CODE_UNITS_V
3178: where uom_code=p_filter_time_uom;
3179: --
3180: CURSOR GET_FIRST_READING(d3_counter_id IN NUMBER) IS
3181: SELECT net_reading,value_timestamp