[Home] [Help] [Dependency Information]
Object Name: | CSF_M_COUNTER_VALUES_INQ# |
---|---|
Object Type: | VIEW |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (30) | ||
USER_ID | NUMBER | |||
COUNTER_GROUP_ID | NUMBER | |||
SOURCE_OBJECT_ID | NUMBER | |||
VALUE_TIMESTAMP | DATE | |||
COUNTER_READING | NUMBER | |||
RESET_FLAG | VARCHAR2 | (1) | ||
RESET_REASON | VARCHAR2 | (255) | ||
PRE_RESET_LAST_RDG | NUMBER | |||
POST_RESET_FIRST_RDG | NUMBER | |||
MISC_READING_TYPE | VARCHAR2 | (30) | ||
MISC_READING | NUMBER | |||
COUNTER_VALUE_ID | NUMBER | |||
COUNTER_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
SEQNO$$ | NUMBER | |||
TRANID$$ | NUMBER | (10) | ||
VERSION$$ | NUMBER | (10) | ||
SOURCE_TRANSACTION_CODE | VARCHAR2 | (30) | ||
SOURCE_TRANSACTION_ID | NUMBER | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
NET_READING | NUMBER | |||
LIFE_TO_DATE_READING | NUMBER | |||
ADJUSTMENT_TYPE | VARCHAR2 | (30) | ||
ADJUSTMENT_READING | NUMBER | |||
DISABLED_FLAG | VARCHAR2 | (1) | ||
RESET_MODE | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
INCLUDE_TARGET_RESETS | VARCHAR2 | (1) | ||
SOURCE_CODE | VARCHAR2 | (30) | ||
SOURCE_LINE_ID | NUMBER | |||
COMMENTS | VARCHAR2 | (2000) | ||
AUTOMATIC_ROLLOVER_FLAG | VARCHAR2 | (1) | ||
MIGRATED_FLAG | VARCHAR2 | (1) | ||
RESET_COUNTER_READING | NUMBER | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
SERVER_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT CLID$$CS
, USER_ID
, COUNTER_GROUP_ID
, SOURCE_OBJECT_ID
, VALUE_TIMESTAMP
, COUNTER_READING
, RESET_FLAG
, RESET_REASON
, PRE_RESET_LAST_RDG
, POST_RESET_FIRST_RDG
, MISC_READING_TYPE
, MISC_READING
, COUNTER_VALUE_ID
, COUNTER_ID
, LAST_UPDATE_DATE
, DMLTYPE$$
, SEQNO$$
, TRANID$$
, VERSION$$
, SOURCE_TRANSACTION_CODE
, SOURCE_TRANSACTION_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, NET_READING
, LIFE_TO_DATE_READING
, ADJUSTMENT_TYPE
, ADJUSTMENT_READING
, DISABLED_FLAG
, RESET_MODE
, OBJECT_VERSION_NUMBER
, INCLUDE_TARGET_RESETS
, SOURCE_CODE
, SOURCE_LINE_ID
, COMMENTS
, AUTOMATIC_ROLLOVER_FLAG
, MIGRATED_FLAG
, RESET_COUNTER_READING
, CREATED_BY
, LAST_UPDATED_BY
, SERVER_LAST_UPDATE_DATE
FROM CSM.CSF_M_COUNTER_VALUES_INQ#;
|
|
|