[Home] [Help] [Dependency Information]
Object Name: | MTH_EQUIPMENT_DENORM_D |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | MTH.MTH_EQUIPMENT_DENORM_D |
Subobject Name: | |
Status: | VALID |
This table stores denormalized data for equipment hierarchy.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_EQUIPMENT_DENORM_D_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL8_LEVEL_NAME |
MTH_EQUIPMENT_DENORM_D_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEVEL9_LEVEL_NAME |
MTH_EQUIPMENT_DENORM_D_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DIMENSION_KEY |
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 |
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;
MTH.MTH_EQUIPMENT_DENORM_D does not reference any database object
MTH.MTH_EQUIPMENT_DENORM_D is referenced by following:
|
|
|