VIEW: APPS.OKX_COUNTER_VALUES_V

Source

View Text - Preformatted

SELECT CV.COUNTER_VALUE_ID COUNTER_VALUE_ID, CV.COUNTER_GRP_LOG_ID COUNTER_GRP_LOG_ID, CV.COUNTER_ID COUNTER_ID, CV.VALUE_TIMESTAMP VALUE_TIMESTAMP, TO_NUMBER(NULL) SEQ_NO, CV.COUNTER_READING COUNTER_READING, CV.RESET_FLAG RESET_FLAG, CV.RESET_REASON RESET_REASON, CV.PRE_RESET_LAST_RDG PRE_RESET_LAST_RDG, CV.POST_RESET_FIRST_RDG POST_RESET_FIRST_RDG, CV.MISC_READING_TYPE MISC_READING_TYPE, CV.MISC_READING MISC_READING, TO_NUMBER(NULL) PREV_NET_CURR_DIFF, CV.NET_READING NET_READING, CV.PREV_NET_READING PREV_NET_READING FROM CS_COUNTER_VALUES CV

View Text - HTML Formatted

SELECT CV.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CV.COUNTER_GRP_LOG_ID COUNTER_GRP_LOG_ID
, CV.COUNTER_ID COUNTER_ID
, CV.VALUE_TIMESTAMP VALUE_TIMESTAMP
, TO_NUMBER(NULL) SEQ_NO
, CV.COUNTER_READING COUNTER_READING
, CV.RESET_FLAG RESET_FLAG
, CV.RESET_REASON RESET_REASON
, CV.PRE_RESET_LAST_RDG PRE_RESET_LAST_RDG
, CV.POST_RESET_FIRST_RDG POST_RESET_FIRST_RDG
, CV.MISC_READING_TYPE MISC_READING_TYPE
, CV.MISC_READING MISC_READING
, TO_NUMBER(NULL) PREV_NET_CURR_DIFF
, CV.NET_READING NET_READING
, CV.PREV_NET_READING PREV_NET_READING
FROM CS_COUNTER_VALUES CV