[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTH_ITEM_DENORM_D |
|---|---|
| Object Type: | TABLE |
| Owner: | MTH |
| FND Design Data: |  MTH.MTH_ITEM_DENORM_D
|
| Subobject Name: | |
| Status: | VALID |
This table stores denormalized data for item hierarchy.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTH_ITEM_DENORM_D_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 LEVEL7_NAME
|
| MTH_ITEM_DENORM_D_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LEVEL8_NAME
|
| MTH_ITEM_DENORM_D_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LEVEL9_NAME
|
| MTH_ITEM_DENORM_D_U1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
HIERARCHY_ID
ITEM_FK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HIERARCHY_ID | NUMBER | Yes | Hierarchy identifier | |
| ITEM_FK_KEY | NUMBER | Reference to item identifier | ||
| LEVEL9_FK_KEY | NUMBER | Reference to level 9 of the hierarchy | ||
| LEVEL8_FK_KEY | NUMBER | Reference to level 8 of the hierarchy | ||
| LEVEL7_FK_KEY | NUMBER | Reference to level 7 of the hierarchy | ||
| LEVEL6_FK_KEY | NUMBER | Reference to level 6 of the hierarchy | ||
| LEVEL5_FK_KEY | NUMBER | Reference to level 5 of the hierarchy | ||
| LEVEL4_FK_KEY | NUMBER | Reference to level 4 of the hierarchy | ||
| LEVEL3_FK_KEY | NUMBER | Reference to level 3 of the hierarchy | ||
| LEVEL2_FK_KEY | NUMBER | Reference to level 2 of the hierarchy | ||
| LEVEL1_FK_KEY | NUMBER | Reference to level 1 of the hierarchy | ||
| 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 | ||
| LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
| ITEM_NAME | VARCHAR2 | (240) | Item name | |
| LEVEL9_NAME | VARCHAR2 | (240) | Level 9 name | |
| LEVEL8_NAME | VARCHAR2 | (240) | Level 8 name | |
| LEVEL7_NAME | VARCHAR2 | (240) | Level 7 name | |
| LEVEL6_NAME | VARCHAR2 | (240) | Level 6 name | |
| LEVEL5_NAME | VARCHAR2 | (240) | Level 5 name | |
| LEVEL4_NAME | VARCHAR2 | (240) | Level 4 name | |
| LEVEL3_NAME | VARCHAR2 | (240) | Level 3 name | |
| LEVEL2_NAME | VARCHAR2 | (240) | Level 2 name | |
| LEVEL1_NAME | VARCHAR2 | (240) | Level 1 name |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_ID
, ITEM_FK_KEY
, LEVEL9_FK_KEY
, LEVEL8_FK_KEY
, LEVEL7_FK_KEY
, LEVEL6_FK_KEY
, LEVEL5_FK_KEY
, LEVEL4_FK_KEY
, LEVEL3_FK_KEY
, LEVEL2_FK_KEY
, LEVEL1_FK_KEY
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LEVEL_NUM
, ITEM_NAME
, LEVEL9_NAME
, LEVEL8_NAME
, LEVEL7_NAME
, LEVEL6_NAME
, LEVEL5_NAME
, LEVEL4_NAME
, LEVEL3_NAME
, LEVEL2_NAME
, LEVEL1_NAME
FROM MTH.MTH_ITEM_DENORM_D;
MTH.MTH_ITEM_DENORM_D does not reference any database object
MTH.MTH_ITEM_DENORM_D is referenced by following:
APPS
MTH_EQUIP_OP_SUM_DD_MV
MTH_EQUIP_PROD_SCH_DD_MV
MTH_MTL_CONS_IT_MV
MTH_MTL_PROD_IT_MV
MTH_RES_REQ_IT_MV
MTH_RES_TXN_IT_MV
MTH
MTH_ITEM_DENORM_D#
|
|
|
|