eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	EAM.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:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_MRS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_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:

APPS: EAM_METER_READINGS_INTERFACE