[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_METER_READINGS |
|---|---|
| Object Type: | TABLE |
| Owner: | EAM |
| FND Design Data: |  EAM.EAM_METER_READINGS
|
| Subobject Name: | |
| Status: | VALID |
This table stores actual meter reading values for asset meters. Each row in the table stores the meter id, reading date, the reading value, and the life to date reading. For absolute meters, the reading value is the absolute reading value; for change meters, the reading value indicates the change in reading from the previous reading. If the meter reading is disabled, disabled_flag is set to 'Y'.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EAM_METER_READINGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 METER_READING_ID
|
| EAM_METER_READINGS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WIP_ENTITY_ID
|
| EAM_METER_READINGS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
METER_ID
CURRENT_READING_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| METER_READING_ID | NUMBER | Yes | Meter Reading Identifier | |
| METER_ID | NUMBER | Yes | Meter Identifier | |
| CURRENT_READING | NUMBER | Yes | Current Reading | |
| CURRENT_READING_DATE | DATE | Yes | Current Reading Date | |
| RESET_FLAG | VARCHAR2 | (1) | Reset Flag | |
| LIFE_TO_DATE_READING | NUMBER | Yes | Life to Date Reading | |
| WIP_ENTITY_ID | NUMBER | Work Order Identifier | ||
| DESCRIPTION | VARCHAR2 | (240) | Reading Description | |
| CREATED_BY | NUMBER | Yes | Standard Who Column | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| SOURCE_LINE_ID | NUMBER | Not used | ||
| SOURCE_CODE | VARCHAR2 | (30) | Not used | |
| WO_ENTRY_FAKE_FLAG | VARCHAR2 | (1) | Not used | |
| DISABLE_FLAG | VARCHAR2 | (1) | Flag indicating if it is a disabled meter reading | |
| MIGRATED_FLAG | VARCHAR2 | (1) | Migrated Flag |
Cut, paste (and edit) the following text to query this object:
SELECT METER_READING_ID
, METER_ID
, CURRENT_READING
, CURRENT_READING_DATE
, RESET_FLAG
, LIFE_TO_DATE_READING
, WIP_ENTITY_ID
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SOURCE_LINE_ID
, SOURCE_CODE
, WO_ENTRY_FAKE_FLAG
, DISABLE_FLAG
, MIGRATED_FLAG
FROM EAM.EAM_METER_READINGS;
EAM.EAM_METER_READINGS does not reference any database object
EAM.EAM_METER_READINGS is referenced by following:
APPS
EAM_METER_READINGS
|
|
|
|