[Home] [Help] [Dependency Information]
Object Name: | MTH_ITEM_DENORM_D# |
---|---|
Object Type: | VIEW |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | Yes | ||
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 | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
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
, 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#;
|
|
|