[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTER_READINGS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTER_READINGS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A supplementary view used to simplify forms coding. 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 | Internally generated primary key | ||
COUNTER_NAME | VARCHAR2 | (80) | Yes | Counter name |
COUNTER_DESCRIPTION | VARCHAR2 | (240) | Counter description | |
INITIAL_READING | NUMBER | Initial reading | ||
READING_TYPE | NUMBER | Reading type | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
DIRECTION | VARCHAR2 | (1) | Direction | |
COUNTER_TYPE | VARCHAR2 | (30) | Counter type | |
ROLLOVER_LAST_READING | NUMBER | Rollover last reading | ||
ROLLOVER_FIRST_READING | NUMBER | Rollover first reading | ||
CUSTOMER_VIEW | VARCHAR2 | (1) | Customer view flag | |
FILTER_TYPE | VARCHAR2 | (30) | Filter type | |
FILTER_TIME_UOM | VARCHAR2 | (30) | Filter time UOM | |
GROUP_ID | NUMBER | Counter group identifier | ||
COUNTER_ID | NUMBER | Yes | Counter identifier | |
VALUE_TIMESTAMP | DATE | Counter reading capture date | ||
COUNTER_READING | NUMBER | Counter readings | ||
RESET_MODE | VARCHAR2 | (30) | Counter reset type | |
RESET_REASON | VARCHAR2 | (255) | Reason for resetting the counter readings | |
ADJUSTMENT_TYPE | VARCHAR2 | (30) | Counter adjustment type | |
ADJUSTMENT_READING | NUMBER | Counter adjustment readings | ||
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
CREATION_DATE | DATE | Standard WHO Column | ||
CREATED_BY | NUMBER | (15) | 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 | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE21 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE22 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE23 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE24 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE25 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE26 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE27 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE28 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE29 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE30 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
MIGRATED_FLAG | VARCHAR2 | (1) | Indicator flag to check if this record is a migrated record | |
COMMENTS | VARCHAR2 | (1996) | Counter readings additional information | |
LIFE_TO_DATE_READING | NUMBER | Life to date readings | ||
NET_READING | NUMBER | Net readings | ||
DISABLED_FLAG | VARCHAR2 | (1) | Flag indicating if the counter reading is disabled | |
AUTOMATIC_ROLLOVER_FLAG | VARCHAR2 | (1) | Flag indicating if the counter readings need to be rollovered automatically | |
TRANSACTION_ID | NUMBER | Counter readings transaction identifier | ||
INCLUDE_TARGET_RESETS | VARCHAR2 | (1) | Flag indicating if the counter readings need to include target counters | |
SOURCE_COUNTER_VALUE_ID | NUMBER | Source counter value identifier | ||
READING_BEFORE_RESET | NUMBER | Reading Before Reset | ||
READING_AFTER_RESET | NUMBER | Reading After Reset | ||
INITIAL_READING_FLAG | VARCHAR2 | (1) | Flag indicating if this record is created as Initial Reading |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_VALUE_ID
, COUNTER_NAME
, COUNTER_DESCRIPTION
, INITIAL_READING
, READING_TYPE
, UOM_CODE
, DIRECTION
, COUNTER_TYPE
, ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING
, CUSTOMER_VIEW
, FILTER_TYPE
, FILTER_TIME_UOM
, GROUP_ID
, COUNTER_ID
, VALUE_TIMESTAMP
, COUNTER_READING
, RESET_MODE
, RESET_REASON
, ADJUSTMENT_TYPE
, ADJUSTMENT_READING
, OBJECT_VERSION_NUMBER
, 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
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
, MIGRATED_FLAG
, COMMENTS
, LIFE_TO_DATE_READING
, NET_READING
, DISABLED_FLAG
, AUTOMATIC_ROLLOVER_FLAG
, TRANSACTION_ID
, INCLUDE_TARGET_RESETS
, SOURCE_COUNTER_VALUE_ID
, READING_BEFORE_RESET
, READING_AFTER_RESET
, INITIAL_READING_FLAG
FROM APPS.CSI_COUNTER_READINGS_V;
|
|
|