eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSD.MSD_HIERARCHY_LEVELS

Object Details

Object Name:	MSD_HIERARCHY_LEVELS
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_HIERARCHY_LEVELS
Subobject Name:
Status:	VALID

This table provides the Level Associations within a Hierarchy for a Real Dimension.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_HIERARCHY_LEVELS_U1	NORMAL	UNIQUE	APPS_TS_SEED	HIERARCHY_ID LEVEL_ID PARENT_LEVEL_ID
MSD_HIERARCHY_LEVELS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	LEVEL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_ID	NUMBER		Yes	Hierarchy ID. This is part of the primary Key.
LEVEL_ID	NUMBER		Yes	Level ID. This is part of the primary key.
PARENT_LEVEL_ID	NUMBER		Yes	Parent Level ID. This is part of the primary key.
RELATIONSHIP_VIEW	VARCHAR2	(30)		This is the name of the view in the source instance that stores the relationship between the values in the current level to its parent level values.
LEVEL_VALUE_COLUMN	VARCHAR2	(30)		The column in the source view which has the level value.
LEVEL_VALUE_PK_COLUMN	VARCHAR2	(30)		The column in the source view which has the primary key of the level value in the source instance.
PARENT_VALUE_COLUMN	VARCHAR2	(30)		The column in the source view which has the parent level value.
PARENT_VALUE_PK_COLUMN	VARCHAR2	(30)		The column in the source view which has the primary key of the parent level value in the source instance.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Enhanced who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced who column
PROGRAM_ID	NUMBER			Enhanced who column
PROGRAM_UPDATE_DATE	DATE			Enhanced who column
LEVEL_VALUE_DESC_COLUMN	VARCHAR2	(30)		The column in the source view which has the description of the level value in the source instance.
PARENT_VALUE_DESC_COLUMN	VARCHAR2	(30)		The column in the source view which has the description of the parent level value in the source instance.
PLAN_TYPE	VARCHAR2	(30)		Plan Type

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HIERARCHY_ID
,      LEVEL_ID
,      PARENT_LEVEL_ID
,      RELATIONSHIP_VIEW
,      LEVEL_VALUE_COLUMN
,      LEVEL_VALUE_PK_COLUMN
,      PARENT_VALUE_COLUMN
,      PARENT_VALUE_PK_COLUMN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LEVEL_VALUE_DESC_COLUMN
,      PARENT_VALUE_DESC_COLUMN
,      PLAN_TYPE
FROM MSD.MSD_HIERARCHY_LEVELS;

Dependencies

[top of page]

MSD.MSD_HIERARCHY_LEVELS does not reference any database object

MSD.MSD_HIERARCHY_LEVELS is referenced by following:

APPS: MSD_HIERARCHY_LEVELS