FND Design Data [Home] [Help]

View: OKX_COUNTER_VALUES_V

Product: OKX - Contracts Integration
Description: Historical readings of counters
Implementation/DBA Data: ViewAPPS.OKX_COUNTER_VALUES_V
View Text

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

Columns

Name
COUNTER_VALUE_ID
COUNTER_GRP_LOG_ID
COUNTER_ID
VALUE_TIMESTAMP
SEQ_NO
COUNTER_READING
RESET_FLAG
RESET_REASON
PRE_RESET_LAST_RDG
POST_RESET_FIRST_RDG
MISC_READING_TYPE
MISC_READING
PREV_NET_CURR_DIFF
NET_READING
PREV_NET_READING