[Home] [Help] [Dependency Information]
Object Name: | EAM_FAILURE_HISTORY_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | EAM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|