[Home] [Help] [Dependency Information]
Object Name: | MTH_EQUIPMENT_DENORM_D# |
---|---|
Object Type: | VIEW |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Yes | ||
LEVEL1_LEVEL_KEY | NUMBER | |||
LEVEL1_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL1_HIERARCHY_KEY | NUMBER | |||
LEVEL1_ID | NUMBER | |||
LEVEL2_HIERARCHY_KEY | NUMBER | |||
LEVEL2_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL2_EFFECTIVE_DATE | DATE | |||
LEVEL2_EXPIRATION_DATE | DATE | |||
LEVEL2_ID | NUMBER | |||
LEVEL2_LEVEL_KEY | NUMBER | |||
LEVEL2_PARENT_KEY | NUMBER | |||
LEVEL3_PARENT_KEY | NUMBER | |||
LEVEL3_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL3_EFFECTIVE_DATE | DATE | |||
LEVEL3_LEVEL_KEY | NUMBER | |||
LEVEL3_ID | NUMBER | |||
LEVEL3_HIERARCHY_KEY | NUMBER | |||
LEVEL3_EXPIRATION_DATE | DATE | |||
LEVEL4_EXPIRATION_DATE | DATE | |||
LEVEL4_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL4_LEVEL_KEY | NUMBER | |||
LEVEL4_ID | NUMBER | |||
LEVEL4_HIERARCHY_KEY | NUMBER | |||
LEVEL4_PARENT_KEY | NUMBER | |||
LEVEL4_EFFECTIVE_DATE | DATE | |||
LEVEL5_ID | NUMBER | |||
LEVEL5_LEVEL_KEY | NUMBER | |||
LEVEL5_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL5_EXPIRATION_DATE | DATE | |||
LEVEL5_HIERARCHY_KEY | NUMBER | |||
LEVEL5_PARENT_KEY | NUMBER | |||
LEVEL5_EFFECTIVE_DATE | DATE | |||
LEVEL6_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL6_LEVEL_KEY | NUMBER | |||
LEVEL6_PARENT_KEY | NUMBER | |||
LEVEL6_HIERARCHY_KEY | NUMBER | |||
LEVEL6_ID | NUMBER | |||
LEVEL6_EFFECTIVE_DATE | DATE | |||
LEVEL6_EXPIRATION_DATE | DATE | |||
LEVEL7_EFFECTIVE_DATE | DATE | |||
LEVEL7_PARENT_KEY | NUMBER | |||
LEVEL7_LEVEL_KEY | NUMBER | |||
LEVEL7_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL7_HIERARCHY_KEY | NUMBER | |||
LEVEL7_EXPIRATION_DATE | DATE | |||
LEVEL7_ID | NUMBER | |||
LEVEL8_HIERARCHY_KEY | NUMBER | |||
LEVEL8_PARENT_KEY | NUMBER | |||
LEVEL8_DESCRIPTION | VARCHAR2 | (40) | ||
LEVEL8_LEVEL_KEY | NUMBER | |||
LEVEL8_ID | NUMBER | |||
LEVEL8_EXPIRATION_DATE | DATE | |||
LEVEL8_EFFECTIVE_DATE | DATE | |||
LEVEL9_PARENT_KEY | NUMBER | |||
LEVEL9_ID | NUMBER | |||
LEVEL9_EXPIRATION_DATE | DATE | |||
LEVEL9_EFFECTIVE_DATE | DATE | |||
LEVEL9_HIERARCHY_KEY | NUMBER | |||
LEVEL9_LEVEL_KEY | NUMBER | |||
LEVEL9_DESCRIPTION | VARCHAR2 | (40) | ||
EQUIPMENT_FK_KEY | NUMBER | |||
EQUIPMENT_EXPIRATION_DATE | DATE | |||
EQUIPMENT_HIERARCHY_KEY | NUMBER | |||
EQUIPMENT_ID | NUMBER | |||
EQUIPMENT_PARENT_KEY | NUMBER | |||
EQUIPMENT_DESCRIPTION | VARCHAR2 | (40) | ||
EQUIPMENT_EFFECTIVE_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LEVEL1_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL2_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL3_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL4_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL5_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL6_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL7_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL8_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL9_LEVEL_NAME | VARCHAR2 | (100) | ||
EQUIPMENT_LEVEL_NAME | VARCHAR2 | (100) | ||
LEVEL_NUM | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_KEY
, LEVEL1_LEVEL_KEY
, LEVEL1_DESCRIPTION
, LEVEL1_HIERARCHY_KEY
, LEVEL1_ID
, LEVEL2_HIERARCHY_KEY
, LEVEL2_DESCRIPTION
, LEVEL2_EFFECTIVE_DATE
, LEVEL2_EXPIRATION_DATE
, LEVEL2_ID
, LEVEL2_LEVEL_KEY
, LEVEL2_PARENT_KEY
, LEVEL3_PARENT_KEY
, LEVEL3_DESCRIPTION
, LEVEL3_EFFECTIVE_DATE
, LEVEL3_LEVEL_KEY
, LEVEL3_ID
, LEVEL3_HIERARCHY_KEY
, LEVEL3_EXPIRATION_DATE
, LEVEL4_EXPIRATION_DATE
, LEVEL4_DESCRIPTION
, LEVEL4_LEVEL_KEY
, LEVEL4_ID
, LEVEL4_HIERARCHY_KEY
, LEVEL4_PARENT_KEY
, LEVEL4_EFFECTIVE_DATE
, LEVEL5_ID
, LEVEL5_LEVEL_KEY
, LEVEL5_DESCRIPTION
, LEVEL5_EXPIRATION_DATE
, LEVEL5_HIERARCHY_KEY
, LEVEL5_PARENT_KEY
, LEVEL5_EFFECTIVE_DATE
, LEVEL6_DESCRIPTION
, LEVEL6_LEVEL_KEY
, LEVEL6_PARENT_KEY
, LEVEL6_HIERARCHY_KEY
, LEVEL6_ID
, LEVEL6_EFFECTIVE_DATE
, LEVEL6_EXPIRATION_DATE
, LEVEL7_EFFECTIVE_DATE
, LEVEL7_PARENT_KEY
, LEVEL7_LEVEL_KEY
, LEVEL7_DESCRIPTION
, LEVEL7_HIERARCHY_KEY
, LEVEL7_EXPIRATION_DATE
, LEVEL7_ID
, LEVEL8_HIERARCHY_KEY
, LEVEL8_PARENT_KEY
, LEVEL8_DESCRIPTION
, LEVEL8_LEVEL_KEY
, LEVEL8_ID
, LEVEL8_EXPIRATION_DATE
, LEVEL8_EFFECTIVE_DATE
, LEVEL9_PARENT_KEY
, LEVEL9_ID
, LEVEL9_EXPIRATION_DATE
, LEVEL9_EFFECTIVE_DATE
, LEVEL9_HIERARCHY_KEY
, LEVEL9_LEVEL_KEY
, LEVEL9_DESCRIPTION
, EQUIPMENT_FK_KEY
, EQUIPMENT_EXPIRATION_DATE
, EQUIPMENT_HIERARCHY_KEY
, EQUIPMENT_ID
, EQUIPMENT_PARENT_KEY
, EQUIPMENT_DESCRIPTION
, EQUIPMENT_EFFECTIVE_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LEVEL1_LEVEL_NAME
, LEVEL2_LEVEL_NAME
, LEVEL3_LEVEL_NAME
, LEVEL4_LEVEL_NAME
, LEVEL5_LEVEL_NAME
, LEVEL6_LEVEL_NAME
, LEVEL7_LEVEL_NAME
, LEVEL8_LEVEL_NAME
, LEVEL9_LEVEL_NAME
, EQUIPMENT_LEVEL_NAME
, LEVEL_NUM
FROM MTH.MTH_EQUIPMENT_DENORM_D#;
|
|
|