[Home] [Help] [Dependency Information]
Object Name: | EAM_FAILUREINFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_FAILUREINFO_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.EAM_FAILUREINFO_V is not referenced by any database object
|
|
|