[Home] [Help] [Dependency Information]
Object Name: | OKX_COUNTER_VALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_COUNTER_VALUES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Displays the historical readings of counters. A reading has to be considered as a counter instance associated to a sequence number.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_VALUE_ID | NUMBER | Yes | The identifier of the counter value. | |
COUNTER_GRP_LOG_ID | NUMBER | The identifier of the counter group log to which this value belongs. | ||
COUNTER_ID | NUMBER | Yes | The identifier of the counter to which this value belongs. | |
VALUE_TIMESTAMP | DATE | Yes | The date on which this counter reading was taken (maybe different from the date on which the reading is enteerd in the system). | |
SEQ_NO | NUMBER | The sequence number. (Install Base obsoleted this column) | ||
COUNTER_READING | NUMBER | Yes | The counter reading. | |
RESET_FLAG | VARCHAR2 | (1) | Indicates whether this counter reading is a reset reading or not. | |
RESET_REASON | VARCHAR2 | (255) | Mandatory only if the RESET_FLAG = 'Y'. | |
PRE_RESET_LAST_RDG | NUMBER | Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_LAST_READING for that counter. | ||
POST_RESET_FIRST_RDG | NUMBER | Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_FIRST_READING for that counter. | ||
MISC_READING_TYPE | VARCHAR2 | (30) | A lookup for different types of miscellaneous readings. | |
MISC_READING | NUMBER | Valid and mandatory only if MISC_READING_TYPE IS NOT NULL. | ||
PREV_NET_CURR_DIFF | NUMBER | Difference between counter reading and net reading of previous reading. (Install Base obsoleted this column) | ||
NET_READING | NUMBER | Yes | Net Reading | |
PREV_NET_READING | NUMBER | Previous net reading |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.OKX_COUNTER_VALUES_V;
APPS.OKX_COUNTER_VALUES_V is not referenced by any database object
|
|
|