[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_READINGS_BC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_READINGS_BC_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A backward compatible view for CS_COUNTER_VALUES. This was created to support the pre R12 releases of Counters.
This view will show the readings information for a counter or meter. This table contains the current reading, net reading and life to date reading. It also holds other information such as reading date, reset, adjustments and disabled readings.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_VALUE_ID | NUMBER | Yes | Internally generated primary key | |
COUNTER_ID | NUMBER | Yes | Counter Id | |
VALUE_TIMESTAMP | DATE | Yes | Counter reading capture date | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
CONTEXT | VARCHAR2 | (30) | Standard DFF Column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
COUNTER_GRP_LOG_ID | NUMBER | Counter group log identifier | ||
COUNTER_READING | NUMBER | Yes | Counter readings | |
RESET_FLAG | VARCHAR2 | (1) | Counter reset type | |
RESET_REASON | VARCHAR2 | (255) | Reason for resetting the counter readings | |
MISC_READING_TYPE | VARCHAR2 | (30) | Counter adjustment type | |
MISC_READING | NUMBER | Counter adjustment readings | ||
SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
VALID_FLAG | VARCHAR2 | (1) | Flag indicating if the counter reading is disabled | |
COMMENTS | VARCHAR2 | (2000) | Counter readings additional information | |
PRE_RESET_LAST_RDG | NUMBER | Reading Before Reset | ||
POST_RESET_FIRST_RDG | NUMBER | Reading After Reset | ||
NET_READING | NUMBER | Yes | Net Reading | |
PREV_NET_READING | NUMBER | Previous Net Reading | ||
OVERRIDE_VALID_FLAG | VARCHAR2 | (1) | Override Valid Flag | |
INITIAL_READING_FLAG | VARCHAR2 | (1) | Flag indicating that this record is an Initial Reading |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_VALUE_ID
, COUNTER_ID
, VALUE_TIMESTAMP
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, OBJECT_VERSION_NUMBER
, COUNTER_GRP_LOG_ID
, COUNTER_READING
, RESET_FLAG
, RESET_REASON
, MISC_READING_TYPE
, MISC_READING
, SECURITY_GROUP_ID
, VALID_FLAG
, COMMENTS
, PRE_RESET_LAST_RDG
, POST_RESET_FIRST_RDG
, NET_READING
, PREV_NET_READING
, OVERRIDE_VALID_FLAG
, INITIAL_READING_FLAG
FROM APPS.CSI_COUNTER_READINGS_BC_V;
|
|
|