Skip to content

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

TABLE: MTH.MTH_EQUIPMENT_DENORM_D

Object Details
Object Name: MTH_EQUIPMENT_DENORM_D
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_EQUIPMENT_DENORM_D
Subobject Name:
Status: VALID


This table stores denormalized data for equipment hierarchy.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_EQUIPMENT_DENORM_D_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL8_LEVEL_NAME
MTH_EQUIPMENT_DENORM_D_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL9_LEVEL_NAME
MTH_EQUIPMENT_DENORM_D_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIMENSION_KEY
Columns
Name Datatype Length Mandatory Comments
DIMENSION_KEY NUMBER
Yes Dimension identifier
LEVEL1_LEVEL_KEY NUMBER

Reference to Level 1 level identifier
LEVEL1_DESCRIPTION VARCHAR2 (40)
Description for Level 1
LEVEL1_HIERARCHY_KEY NUMBER

Reference to Level 1 hierarchy identifier
LEVEL1_ID NUMBER

Level 1 identifier
LEVEL2_HIERARCHY_KEY NUMBER

Reference to Level 2 hierarchy identifier
LEVEL2_DESCRIPTION VARCHAR2 (40)
Description for Level 2
LEVEL2_EFFECTIVE_DATE DATE

Level 2 effective date
LEVEL2_EXPIRATION_DATE DATE

Level 2 expiration date
LEVEL2_ID NUMBER

Level 2 identifier
LEVEL2_LEVEL_KEY NUMBER

Reference to Level 2 level identifier
LEVEL2_PARENT_KEY NUMBER

Reference to Level 2 parent
LEVEL3_PARENT_KEY NUMBER

Reference to Level 2 parent
LEVEL3_DESCRIPTION VARCHAR2 (40)
Description for Level 3
LEVEL3_EFFECTIVE_DATE DATE

Level 3 effective date
LEVEL3_LEVEL_KEY NUMBER

Reference to Level 3 level identifier
LEVEL3_ID NUMBER

Level 3 identifier
LEVEL3_HIERARCHY_KEY NUMBER

Reference to Level 3 hierarchy identifier
LEVEL3_EXPIRATION_DATE DATE

Level 3 expiration date
LEVEL4_EXPIRATION_DATE DATE

Level 4 expiration date
LEVEL4_DESCRIPTION VARCHAR2 (40)
Description for Level 4
LEVEL4_LEVEL_KEY NUMBER

Reference to Level 4 level identifier
LEVEL4_ID NUMBER

Level 4 identifier
LEVEL4_HIERARCHY_KEY NUMBER

Reference to Level 4 hierarchy identifier
LEVEL4_PARENT_KEY NUMBER

Reference to Level 4 parent
LEVEL4_EFFECTIVE_DATE DATE

Level 4 effective date
LEVEL5_ID NUMBER

Level 5 identifier
LEVEL5_LEVEL_KEY NUMBER

Reference to Level 5 level identifier
LEVEL5_DESCRIPTION VARCHAR2 (40)
Description for Level 5
LEVEL5_EXPIRATION_DATE DATE

Level 5 expiration date
LEVEL5_HIERARCHY_KEY NUMBER

Reference to Level 5 hierarchy identifier
LEVEL5_PARENT_KEY NUMBER

Reference to Level 6 parent
LEVEL5_EFFECTIVE_DATE DATE

Level 5 effective date
LEVEL6_DESCRIPTION VARCHAR2 (40)
Description for Level 6
LEVEL6_LEVEL_KEY NUMBER

Reference to Level 6 level identifier
LEVEL6_PARENT_KEY NUMBER

Reference to Level 6 parent
LEVEL6_HIERARCHY_KEY NUMBER

Reference to Level 6 hierarchy identifier
LEVEL6_ID NUMBER

Level 6 identifier
LEVEL6_EFFECTIVE_DATE DATE

Level 6 effective date
LEVEL6_EXPIRATION_DATE DATE

Level 6 expiration date
LEVEL7_EFFECTIVE_DATE DATE

Level 7 effective date
LEVEL7_PARENT_KEY NUMBER

Reference to Level 7 parent
LEVEL7_LEVEL_KEY NUMBER

Reference to Level 7 level identifier
LEVEL7_DESCRIPTION VARCHAR2 (40)
Description for Level 7
LEVEL7_HIERARCHY_KEY NUMBER

Reference to Level 7 hierarchy identifier
LEVEL7_EXPIRATION_DATE DATE

Level 7 expiration date
LEVEL7_ID NUMBER

Level 7 identifier
LEVEL8_HIERARCHY_KEY NUMBER

Reference to Level 8 hierarchy identifier
LEVEL8_PARENT_KEY NUMBER

Reference to Level 8 parent
LEVEL8_DESCRIPTION VARCHAR2 (40)
Description for Level 8
LEVEL8_LEVEL_KEY NUMBER

Reference to Level 8 level identifier
LEVEL8_ID NUMBER

Level 8 identifier
LEVEL8_EXPIRATION_DATE DATE

Level 8 expiration date
LEVEL8_EFFECTIVE_DATE DATE

Level 8 effective date
LEVEL9_PARENT_KEY NUMBER

Reference to Level 9 parent
LEVEL9_ID NUMBER

Level 9 identifier
LEVEL9_EXPIRATION_DATE DATE

Level 9 expiration date
LEVEL9_EFFECTIVE_DATE DATE

Level 10 effective date
LEVEL9_HIERARCHY_KEY NUMBER

Reference to Level 9 hierarchy identifier
LEVEL9_LEVEL_KEY NUMBER

Reference to Level 9 level identifier
LEVEL9_DESCRIPTION VARCHAR2 (40)
Description for Level 9
EQUIPMENT_FK_KEY NUMBER

Reference to Equipment level identifier
EQUIPMENT_EXPIRATION_DATE DATE

Equipment expiration date
EQUIPMENT_HIERARCHY_KEY NUMBER

Reference to Equipment hierarchy identifier
EQUIPMENT_ID NUMBER

Equipment identifier
EQUIPMENT_PARENT_KEY NUMBER

Reference to Equipment parent
EQUIPMENT_DESCRIPTION VARCHAR2 (40)
Equipment description
EQUIPMENT_EFFECTIVE_DATE DATE

Equipment effective date
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LEVEL1_LEVEL_NAME VARCHAR2 (100)
Level1 level name
LEVEL2_LEVEL_NAME VARCHAR2 (100)
Level2 level name
LEVEL3_LEVEL_NAME VARCHAR2 (100)
Level3 level name
LEVEL4_LEVEL_NAME VARCHAR2 (100)
Level4 level name
LEVEL5_LEVEL_NAME VARCHAR2 (100)
Level5 level name
LEVEL6_LEVEL_NAME VARCHAR2 (100)
Level6 level name
LEVEL7_LEVEL_NAME VARCHAR2 (100)
Level7 level name
LEVEL8_LEVEL_NAME VARCHAR2 (100)
Level8 level name
LEVEL9_LEVEL_NAME VARCHAR2 (100)
Level9 level name
EQUIPMENT_LEVEL_NAME VARCHAR2 (100)
Equipment name
LEVEL_NUM NUMBER

Level number in the hierarchy
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 does not reference any database object

MTH.MTH_EQUIPMENT_DENORM_D is referenced by following:

SchemaAPPS
Materialized ViewMTH_EQUIP_OP_SUM_DD_MV
Materialized ViewMTH_EQUIP_PROD_SCH_DD_MV
Materialized ViewMTH_EQUIP_SHFT_DD_MV
Materialized ViewMTH_EQUIP_ST_SUM_DD_MV
SchemaMTH
ViewMTH_EQUIPMENT_DENORM_D#