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: EAM.EAM_FAILURE_HISTORY_TEMP#

Object Details

Object Name:	EAM_FAILURE_HISTORY_TEMP#
Object Type:	VIEW
Owner:	EAM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GROUP_ID	NUMBER		Yes
ASSET_TYPE	NUMBER
MAINTENANCE_OBJECT_ID	NUMBER
MAINTAINED_NUMBER	VARCHAR2	(30)
DESCRIPTIVE_TEXT	VARCHAR2	(240)
MAINTAINED_GROUP	VARCHAR2	(40)
MAINTAINED_GROUP_ID	NUMBER
WIP_ENTITY_ID	NUMBER
WIP_ENTITY_NAME	VARCHAR2	(240)
ASSET_CATEGORY	VARCHAR2	(163)
ASSET_CATEGORY_ID	NUMBER
ASSET_LOCATION	VARCHAR2	(30)
ORGANIZATION_CODE	VARCHAR2	(3)
MAINT_ORGANIZATION_ID	NUMBER
OWNING_DEPARTMENT	VARCHAR2	(10)
FAILURE_CODE	VARCHAR2	(80)	Yes
CAUSE_CODE	VARCHAR2	(80)	Yes
FAILURE_DATE	DATE
RESOLUTION_CODE	VARCHAR2	(80)
DAYS_BETWEEN_FAILURES	NUMBER
TIME_TO_REPAIR	NUMBER
COMMENTS	VARCHAR2	(2000)
METER_NAME	VARCHAR2	(50)
METER_UOM	VARCHAR2	(3)
READING_BETWEEN_FAILURES	NUMBER
COST_TO_REPAIR	NUMBER
INCLUDE_FOR_READING_AGGR	VARCHAR2	(1)
INCLUDE_FOR_COST_AGGR	VARCHAR2	(1)

Query Text

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


SELECT GROUP_ID
,      ASSET_TYPE
,      MAINTENANCE_OBJECT_ID
,      MAINTAINED_NUMBER
,      DESCRIPTIVE_TEXT
,      MAINTAINED_GROUP
,      MAINTAINED_GROUP_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ASSET_CATEGORY
,      ASSET_CATEGORY_ID
,      ASSET_LOCATION
,      ORGANIZATION_CODE
,      MAINT_ORGANIZATION_ID
,      OWNING_DEPARTMENT
,      FAILURE_CODE
,      CAUSE_CODE
,      FAILURE_DATE
,      RESOLUTION_CODE
,      DAYS_BETWEEN_FAILURES
,      TIME_TO_REPAIR
,      COMMENTS
,      METER_NAME
,      METER_UOM
,      READING_BETWEEN_FAILURES
,      COST_TO_REPAIR
,      INCLUDE_FOR_READING_AGGR
,      INCLUDE_FOR_COST_AGGR
FROM EAM.EAM_FAILURE_HISTORY_TEMP#;

Dependencies

[top of page]

EAM.EAM_FAILURE_HISTORY_TEMP# references the following:

EAM: EAM_FAILURE_HISTORY_TEMP

EAM.EAM_FAILURE_HISTORY_TEMP# is referenced by following:

APPS: EAM_FAILURE_HISTORY_TEMP