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_FAILUREINFO_V

Object Details

Object Name:	EAM_FAILUREINFO_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	Unique Identifier of Work Order
FAILURE_ID	NUMBER			Unique failure identifier
FAILURE_ENTRY_ID	NUMBER			Unique Identifier for Failure Information
FAILURE_CODE	VARCHAR2	(80)		Identifier for failure code
FAILURE_DESCRIPTION	VARCHAR2	(2000)		Failure Code Description
CAUSE_CODE	VARCHAR2	(80)		Unique identifier for cause code
CAUSE_DESCRIPTION	VARCHAR2	(2000)		Cause code description
RESOLUTION_CODE	VARCHAR2	(80)		Unique identifier for resolution code
RESOLUTION_DESCRIPTION	VARCHAR2	(2000)		Resolution code description
FAILURE_CODE_REQUIRED	VARCHAR2	(240)		Flag to indicate if Failure Information is required to be entered at the time of Work Completion
FAILURE_DATE	DATE			Date of which Failure Occurred
COMMENTS	VARCHAR2	(2000)		Failure Comments
INVENTORY_ITEM_ID	NUMBER			Unique identifier of the Asset's Group
SET_ID	NUMBER			Unique Identifier of Failure Set
SET_NAME	VARCHAR2	(80)		Failure Set Name
STATUS_TYPE	NUMBER		Yes	Work Order Status Type
CREATION_DATE	DATE		Yes	Work Order Creation Date

Query Text

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


SELECT WIP_ENTITY_ID
,      FAILURE_ID
,      FAILURE_ENTRY_ID
,      FAILURE_CODE
,      FAILURE_DESCRIPTION
,      CAUSE_CODE
,      CAUSE_DESCRIPTION
,      RESOLUTION_CODE
,      RESOLUTION_DESCRIPTION
,      FAILURE_CODE_REQUIRED
,      FAILURE_DATE
,      COMMENTS
,      INVENTORY_ITEM_ID
,      SET_ID
,      SET_NAME
,      STATUS_TYPE
,      CREATION_DATE
FROM APPS.EAM_FAILUREINFO_V;

Dependencies

[top of page]

APPS.EAM_FAILUREINFO_V references the following:

APPS: EAM_ASSET_FAILURES; EAM_ASSET_FAILURE_CODES; EAM_CAUSE_CODES; EAM_FAILURE_CODES; EAM_FAILURE_SETS; EAM_FAILURE_SET_ASSOCIATIONS; EAM_RESOLUTION_CODES; EAM_WORK_ORDER_DETAILS; WIP_DISCRETE_JOBS

APPS.EAM_FAILUREINFO_V is not referenced by any database object