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

TABLE: MTH.MTH_ITEM_DENORM_D

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


This table stores denormalized data for item hierarchy.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_ITEM_DENORM_D_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL7_NAME
MTH_ITEM_DENORM_D_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL8_NAME
MTH_ITEM_DENORM_D_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEVEL9_NAME
MTH_ITEM_DENORM_D_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHIERARCHY_ID
ColumnITEM_FK_KEY
Columns
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
Query Text

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;

Dependencies

[top of page]

MTH.MTH_ITEM_DENORM_D does not reference any database object

MTH.MTH_ITEM_DENORM_D is referenced by following:

SchemaAPPS
Materialized ViewMTH_EQUIP_OP_SUM_DD_MV
Materialized ViewMTH_EQUIP_PROD_SCH_DD_MV
SynonymMTH_ITEM_DENORM_D
Materialized ViewMTH_MTL_CONS_IT_MV
Materialized ViewMTH_MTL_PROD_IT_MV
Materialized ViewMTH_RES_REQ_IT_MV
Materialized ViewMTH_RES_TXN_IT_MV