DBA Data[Home] [Help] [Dependency Information]

TABLE: EAM.EAM_FAILURE_HISTORY_TEMP

Object Details
Object Name: EAM_FAILURE_HISTORY_TEMP
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_FAILURE_HISTORY_TEMP
Subobject Name:
Status: VALID


Temporary Table used to hold data for displaying Failure History of an Asset in Oracle Applications. Data does not persist in this table and is only used when a user tries to view the Failure History of an Asset.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_FAILURE_HISTORY_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes Identifier for performed Search
ASSET_TYPE NUMBER

Asset or Rebuild Item
MAINTENANCE_OBJECT_ID NUMBER

Identifier for Maintenance Object
MAINTAINED_NUMBER VARCHAR2 (30)
Maintained Serial Number
DESCRIPTIVE_TEXT VARCHAR2 (240)
Serial Number Descriptive Text
MAINTAINED_GROUP VARCHAR2 (40)
Concatenated Segments of the Maintained Item
MAINTAINED_GROUP_ID NUMBER

Identifier for the Maintained Item
WIP_ENTITY_ID NUMBER

Identifier for the Work Order
WIP_ENTITY_NAME VARCHAR2 (240)
Work Order Name
ASSET_CATEGORY VARCHAR2 (163)
Concatenated Segments of the Category Asset Number belongs to
ASSET_CATEGORY_ID NUMBER

Identifier for the Category Asset Number belongs to
ASSET_LOCATION VARCHAR2 (30)
Asset Number Location
ORGANIZATION_CODE VARCHAR2 (3)
Maintenance Organization Code
MAINT_ORGANIZATION_ID NUMBER

Identifier for Maintenance Organization
OWNING_DEPARTMENT VARCHAR2 (10)
Maintenance Department Code
FAILURE_CODE VARCHAR2 (80) Yes Identifier for failure code
CAUSE_CODE VARCHAR2 (80) Yes Identifier for cause code
FAILURE_DATE DATE

Failure Date
RESOLUTION_CODE VARCHAR2 (80)
Identifier for resolution code
DAYS_BETWEEN_FAILURES NUMBER

Days Since Last Failure
TIME_TO_REPAIR NUMBER

Time (Hours) taken to Complete the Work Order since the time Failure was reported
COMMENTS VARCHAR2 (2000)
Failure Comments
METER_NAME VARCHAR2 (50)
Failure Meter Name
METER_UOM VARCHAR2 (3)
Failure Meter UOM
READING_BETWEEN_FAILURES NUMBER

Meter Reading since last Failure
COST_TO_REPAIR NUMBER

Repair Costs of the Failure Work Order
INCLUDE_FOR_READING_AGGR VARCHAR2 (1)
Flag to indicate if the record needs to be considered for the Meter Reading Aggregation
INCLUDE_FOR_COST_AGGR VARCHAR2 (1)
Flag to indicate if the record needs to be considered for the Meter Reading Aggregation
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 does not reference any database object

EAM.EAM_FAILURE_HISTORY_TEMP is referenced by following:

SchemaAPPS
SynonymEAM_FAILURE_HISTORY_TEMP