[Home] [Help]
[Dependency Information]
[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:
CSM
CSF_M_COUNTER_VALUES_INQ#
|
|
|
|