[Home] [Help] [Dependency Information]
Object Name: | CSF_M_COUNTER_VALUES_INQ |
---|---|
Object Type: | TABLE |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (30) | Name of the Client | |
USER_ID | NUMBER | The identifier of the User | ||
COUNTER_GROUP_ID | NUMBER | The identifier of the counter group to which the value belongs to | ||
SOURCE_OBJECT_ID | NUMBER | The identifier of the source object | ||
VALUE_TIMESTAMP | DATE | The date on which the counter reading was taken(may be different from the date the reading is entered in the system) | ||
COUNTER_READING | NUMBER | The counter reading | ||
RESET_FLAG | VARCHAR2 | (1) | Indicate whether this counter reading is a reset reading or not | |
RESET_REASON | VARCHAR2 | (255) | Madatory only if the RESET_FLAG='Y' | |
PRE_RESET_LAST_RDG | NUMBER | Madatory only if the RESET_FLAG='Y'. Will be defaulted from the ROLLOVER_LAST_READING for that counter | ||
POST_RESET_FIRST_RDG | NUMBER | Madatory 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 | ||
COUNTER_VALUE_ID | NUMBER | The identifier of the counter value | ||
COUNTER_ID | NUMBER | The identifier of the counter to which this value belongs | ||
LAST_UPDATE_DATE | DATE | Standard WHO table | ||
DMLTYPE$$ | VARCHAR2 | (1) | Type of the DML operation performed at the client | |
SEQNO$$ | NUMBER | Sequence Nmber to uniquely identify this record, among the records, which were performed | ||
TRANID$$ | NUMBER | (10) | Id of the synch session in which this record was populated | |
VERSION$$ | NUMBER | (10) | The identifier of the Version Number | |
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;
CSM.CSF_M_COUNTER_VALUES_INQ does not reference any database object
CSM.CSF_M_COUNTER_VALUES_INQ is referenced by following:
|
|
|