[Home] [Help] [Dependency Information]
Object Name: | MTH_ITEM_DENORM_D_TMP |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | MTH.MTH_ITEM_DENORM_D_TMP |
Subobject Name: | |
Status: | VALID |
MTH.MTH_ITEM_DENORM_D_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | |||
ITEM_FK_KEY | NUMBER | |||
LEVEL9_FK_KEY | NUMBER | |||
LEVEL8_FK_KEY | NUMBER | |||
LEVEL7_FK_KEY | NUMBER | |||
LEVEL6_FK_KEY | NUMBER | |||
LEVEL5_FK_KEY | NUMBER | |||
LEVEL4_FK_KEY | NUMBER | |||
LEVEL3_FK_KEY | NUMBER | |||
LEVEL2_FK_KEY | NUMBER | |||
LEVEL1_FK_KEY | NUMBER | |||
LEVEL_NUM | NUMBER | |||
ITEM_NAME | VARCHAR2 | (240) | ||
LEVEL9_NAME | VARCHAR2 | (240) | ||
LEVEL8_NAME | VARCHAR2 | (240) | ||
LEVEL7_NAME | VARCHAR2 | (240) | ||
LEVEL6_NAME | VARCHAR2 | (240) | ||
LEVEL5_NAME | VARCHAR2 | (240) | ||
LEVEL4_NAME | VARCHAR2 | (240) | ||
LEVEL3_NAME | VARCHAR2 | (240) | ||
LEVEL2_NAME | VARCHAR2 | (240) | ||
LEVEL1_NAME | VARCHAR2 | (240) |
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
, 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_TMP;
MTH.MTH_ITEM_DENORM_D_TMP does not reference any database object
MTH.MTH_ITEM_DENORM_D_TMP is referenced by following:
|
|
|