DBA Data[Home] [Help] [Dependency Information]

TABLE: EAM.EAM_METER_READINGS_INTERFACE

Object Details
Object Name: EAM_METER_READINGS_INTERFACE
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_METER_READINGS_INTERFACE
Subobject Name:
Status: VALID


This table stores records that are to be imported as meter readings into Oracle Applications.
Users enter data into the table from their legacy system. When the Asset Meter Import concurrent program runs, it processes the table, validates the data, and imports those data into eam_meter_readings table in the EAM system.
This table is used to populate data before executing EAM_MET_RD_INTERFACE concurrent program.
Scope: public
Product: EAM
Lifecycle: active
Display Name: EAM_METER_READINGS_INTERFACE
Category: OPEN_INTERFACE EAM_MET_RD_INTERFACE 1
Category: BUSINESS_ENTITY EAM_METER_READING


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_MRS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes Interface Process Group Identifier
PROCESS_STATUS NUMBER
Yes Process Status
PROCESS_PHASE NUMBER
Yes Process Phase
METER_ID NUMBER

Meter Identifier
METER_NAME VARCHAR2 (30)
Meter Name
READING_VALUE NUMBER

Reading Value
READING_DATE DATE
Yes Date when the reading was taken
RESET_FLAG VARCHAR2 (1)
Reset Flag
LIFE_TO_DATE_READING NUMBER

Life to Date Reading
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
WIP_ENTITY_ID NUMBER

Work Order Identifier
WORK_ORDER_NAME VARCHAR2 (240)
Work Order Name
DESCRIPTION VARCHAR2 (240)
Description for reading value
SOURCE_CODE VARCHAR2 (30)
Source Code
SOURCE_LINE_ID NUMBER

Source Line ID
INTERFACE_ID NUMBER

Interface identifier
CREATED_BY NUMBER

Standard Who Column
CREATED_BY_NAME VARCHAR2 (100)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

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
READING_CHANGE NUMBER

Reading Change
DISABLE_FLAG VARCHAR2 (1)
Flag to disable meter reading value
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GROUP_ID
,      PROCESS_STATUS
,      PROCESS_PHASE
,      METER_ID
,      METER_NAME
,      READING_VALUE
,      READING_DATE
,      RESET_FLAG
,      LIFE_TO_DATE_READING
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      WORK_ORDER_NAME
,      DESCRIPTION
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      INTERFACE_ID
,      CREATED_BY
,      CREATED_BY_NAME
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BY_NAME
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      READING_CHANGE
,      DISABLE_FLAG
FROM EAM.EAM_METER_READINGS_INTERFACE;

Dependencies

[top of page]

EAM.EAM_METER_READINGS_INTERFACE does not reference any database object

EAM.EAM_METER_READINGS_INTERFACE is referenced by following:

SchemaAPPS
SynonymEAM_METER_READINGS_INTERFACE