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

VIEW: MTH.MTH_EQUIPMENT_DENORM_D#

Object Details
Object Name: MTH_EQUIPMENT_DENORM_D#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

MTH.MTH_EQUIPMENT_DENORM_D# references the following:

SchemaMTH
TableMTH_EQUIPMENT_DENORM_D
MTH.MTH_EQUIPMENT_DENORM_D# is referenced by following:

SchemaAPPS
SynonymMTH_EQUIPMENT_DENORM_D