[Home] [Help] [Dependency Information]
Object Name: | CSF_M_COUNTER_VALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This view holds information about the counter values
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | The Unique Access Identifier | ||
USER_ID | NUMBER | The unique User Identifier | ||
COUNTER_GROUP_ID | NUMBER | The Counter Group Identifier | ||
SOURCE_OBJECT_ID | NUMBER | Source Object Identifier | ||
VALUE_TIMESTAMP | DATE | The date on which this counter reading was taken | ||
COUNTER_READING | NUMBER | 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 lookups for different types of LookUp readings | |
MISC_READING | NUMBER | Valid and mandatory only if the MISC_READING_TYPE IS NOT NULL | ||
COUNTER_VALUE_ID | NUMBER | Yes | The Counter Value Identifier | |
COUNTER_ID | NUMBER | The Counter Identifier | ||
LAST_UPDATE_DATE | DATE | Standard WHO Information | ||
SOURCE_TRANSACTION_CODE | VARCHAR2 | (13) | ||
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 ACCESS_ID
, 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
, 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 APPS.CSF_M_COUNTER_VALUES_V;
APPS.CSF_M_COUNTER_VALUES_V is not referenced by any database object
|
|
|