[Home] [Help] [Dependency Information]
Object Name: | EAM_FAILURE_HISTORY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | EAM |
FND Design Data: | EAM.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EAM_FAILURE_HISTORY_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GROUP_ID |
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 |
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;
EAM.EAM_FAILURE_HISTORY_TEMP does not reference any database object
EAM.EAM_FAILURE_HISTORY_TEMP is referenced by following:
|
|
|