Product: | OKX - Contracts Integration |
---|---|
Description: | Historical readings of counters |
Implementation/DBA Data: | APPS.OKX_COUNTER_VALUES_V |
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