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]

VIEW: APPS.EAM_ASSET_METERS_V

Object Details

Object Name:	EAM_ASSET_METERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_ASSET_METERS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row Id
ASSOCIATION_ID	NUMBER		Association Id
INITIAL_READING	NUMBER
METER_ID	NUMBER		Meter Identifier
ORGANIZATION_ID	NUMBER		Organization Identifier
ASSET_GROUP_ID	NUMBER		Asset Group Identifier
ASSET_NUMBER	VARCHAR2	(30)	Asset number
METER_NAME	VARCHAR2	(80)	Meter Name
METER_TYPE	NUMBER
METER_UOM	VARCHAR2	(3)	Unit of Measure of the meter
VALUE_CHANGE_DIR	VARCHAR2	(1)	Meter value change direction
EAM_REQUIRED_FLAG	VARCHAR2	(1)	EAM Required Flag
PRIMARY_FAILURE_FLAG	VARCHAR2	(1)	Primary Failure Flag
USED_IN_SCHEDULING	VARCHAR2	(1)	Meter used in scheduling flag
USER_DEFINED_RATE	NUMBER		User defined meter usage rate
USE_PAST_READING	NUMBER		Number of past readings
DESCRIPTION	VARCHAR2	(240)	Description of meter
FROM_EFFECTIVE_DATE	DATE		Effective From Date of meter
TO_EFFECTIVE_DATE	DATE		Effective To date of meter
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute Category
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
MAINTENANCE_OBJECT_TYPE	NUMBER
MAINTENANCE_OBJECT_ID	NUMBER
CREATION_ORGANIZATION_ID	NUMBER
TMPL_FLAG	CHAR	(1)
SOURCE_TMPL_ID	NUMBER
EAM_ITEM_TYPE	NUMBER		EAM Item Type
ASSET_GROUP	VARCHAR2	(40)	Asset Group
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
ASSET_DESCRIPTION	VARCHAR2	(240)	Asset Number/Group Description
SOURCE_METER_NAME	VARCHAR2	(80)	Source Counter
FACTOR	NUMBER		Factor
INITIAL_READING_DATE	DATE		Initial Reading Date
RELATIONSHIP_START_DATE	DATE		Relationship Start Date
MAINT_ORGANIZATION_ID	NUMBER		Maint Organization Id

Query Text

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


SELECT ROW_ID
,      ASSOCIATION_ID
,      INITIAL_READING
,      METER_ID
,      ORGANIZATION_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      METER_NAME
,      METER_TYPE
,      METER_UOM
,      VALUE_CHANGE_DIR
,      EAM_REQUIRED_FLAG
,      PRIMARY_FAILURE_FLAG
,      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
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      CREATION_ORGANIZATION_ID
,      TMPL_FLAG
,      SOURCE_TMPL_ID
,      EAM_ITEM_TYPE
,      ASSET_GROUP
,      ORGANIZATION_CODE
,      ASSET_DESCRIPTION
,      SOURCE_METER_NAME
,      FACTOR
,      INITIAL_READING_DATE
,      RELATIONSHIP_START_DATE
,      MAINT_ORGANIZATION_ID
FROM APPS.EAM_ASSET_METERS_V;

Dependencies

[top of page]

APPS.EAM_ASSET_METERS_V references the following:

APPS: CSI_COUNTERS_B; CSI_COUNTERS_TL; CSI_COUNTER_ASSOCIATIONS; CSI_COUNTER_RELATIONSHIPS; CSI_COUNTER_TEMPLATE_B; CSI_COUNTER_TEMPLATE_TL; CSI_CTR_ITEM_ASSOCIATIONS; CSI_ITEM_INSTANCES; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_ASSET_METERS_V is referenced by following:

APPS: EAM_PM_ASSET_ACTIVITY_V