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_RUNTIME_INTERVAL_V

Object Details

Object Name:	EAM_RUNTIME_INTERVAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_RUNTIME_INTERVAL_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
RULE_ID	NUMBER		Rule identifier
ACTIVITY_ASSOCIATION_ID	NUMBER		Activity association identifier
PM_SCHEDULE_ID	NUMBER		PM schedule identifier
RULE_TYPE	NUMBER		Rule type of this rule
METER_ID	NUMBER		Meter identifier
METER_NAME	VARCHAR2	(80)	Name of the meter
METER_UOM	VARCHAR2	(3)	Meter unit of measure
VALUE_CHANGE_DIR	VARCHAR2	(1)	The value change direction for the meter
METER_DESCRIPTION	VARCHAR2	(240)	Meter description
RUNTIME_INTERVAL	NUMBER		Runtime Interval. This will be used in the PM calculations
LAST_SERVICE_READING	NUMBER		Last service reading
CREATED_BY	NUMBER		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
EFFECTIVE_READING_FROM	NUMBER		Reading from which this rule is effective
EFFECTIVE_READING_TO	NUMBER		Reading till which this reading will be effective
EFFECTIVE_DATE_FROM	DATE		Date from which this rule is effective
EFFECTIVE_DATE_TO	DATE		Date till which this rule will be effective
USER_DEFINED_RATE	NUMBER		User defined rate

Query Text

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


SELECT RULE_ID
,      ACTIVITY_ASSOCIATION_ID
,      PM_SCHEDULE_ID
,      RULE_TYPE
,      METER_ID
,      METER_NAME
,      METER_UOM
,      VALUE_CHANGE_DIR
,      METER_DESCRIPTION
,      RUNTIME_INTERVAL
,      LAST_SERVICE_READING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      EFFECTIVE_READING_FROM
,      EFFECTIVE_READING_TO
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      USER_DEFINED_RATE
FROM APPS.EAM_RUNTIME_INTERVAL_V;

Dependencies

[top of page]

APPS.EAM_RUNTIME_INTERVAL_V references the following:

APPS: CSI_COUNTERS_B; CSI_COUNTERS_TL; CSI_COUNTER_TEMPLATE_B; CSI_COUNTER_TEMPLATE_TL; EAM_METERS_UTIL - show dependent code; EAM_PM_LAST_SERVICE; EAM_PM_SCHEDULINGS; EAM_PM_SCHEDULING_RULES

APPS.EAM_RUNTIME_INTERVAL_V is not referenced by any database object