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_METERS

Object Details

Object Name:	EAM_METERS
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_METERS
Subobject Name:
Status:	VALID

This table stores meter templates and meter definitions used in EAM preventive maintenance. When tmpl_flag='Y', the row is a meter template. When tmpl_flag='N' or is null, the row is a meter definition.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_METERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	METER_ID
EAM_METERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	METER_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
METER_ID	NUMBER		Yes	Meter identifier
METER_NAME	VARCHAR2	(50)	Yes	Meter Name
METER_UOM	VARCHAR2	(3)	Yes	Meter's Unit of measure
VALUE_CHANGE_DIR	NUMBER			Value Change Direction
USED_IN_SCHEDULING	VARCHAR2	(1)		Used in Scheduling Flag
USER_DEFINED_RATE	NUMBER			Usage Rate
USE_PAST_READING	NUMBER			Indicator of how many past reading should be used to compute rate
DESCRIPTION	VARCHAR2	(240)		Meter description
FROM_EFFECTIVE_DATE	DATE			Effective start date
TO_EFFECTIVE_DATE	DATE			Effective end date
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
TMPL_FLAG	VARCHAR2	(1)		Flag indicating a meter template
SOURCE_TMPL_ID	NUMBER			The meter template that the meter is created from
INITIAL_READING	NUMBER			The first meter reading upon meter creation
METER_TYPE	NUMBER	(1)		Meter type. 1 indicates absolute meter, 2 indicates change meter
MIGRATED_FLAG	VARCHAR2	(1)		Flag indicating whether the record has been migrated
REQUIRED_FLAG	VARCHAR2	(1)		Flag indicating whether the meter reading entry is required during work order completion

Query Text

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


SELECT METER_ID
,      METER_NAME
,      METER_UOM
,      VALUE_CHANGE_DIR
,      USED_IN_SCHEDULING
,      USER_DEFINED_RATE
,      USE_PAST_READING
,      DESCRIPTION
,      FROM_EFFECTIVE_DATE
,      TO_EFFECTIVE_DATE
,      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
,      TMPL_FLAG
,      SOURCE_TMPL_ID
,      INITIAL_READING
,      METER_TYPE
,      MIGRATED_FLAG
,      REQUIRED_FLAG
FROM EAM.EAM_METERS;

Dependencies

[top of page]

EAM.EAM_METERS does not reference any database object

EAM.EAM_METERS is referenced by following:

EAM: EAM_METERS#