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_LEVELS

Object Details

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

This tableI provides the Levels, their Owning Dimension. It also specifies the Level Type. The possible values for Level Type are :
1. Top Level
2. Bottom Level
3. Intermediate Level
This is based on the MSD_LEVEL_TYPE lookup..

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_LEVELS_U1	NORMAL	UNIQUE	APPS_TS_SEED	PLAN_TYPE LEVEL_ID
MSD_LEVELS_U2	NORMAL	UNIQUE	APPS_TS_SEED	PLAN_TYPE LEVEL_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
LEVEL_ID	NUMBER		Yes	Unique ID for the level.
LEVEL_NAME	VARCHAR2	(30)	Yes	Level name.
DESCRIPTION	VARCHAR2	(240)	Yes	Level description.
DIMENSION_CODE	VARCHAR2	(3)	Yes	Dimension identifier to which the level belongs.
LEVEL_TYPE_CODE	VARCHAR2	(1)	Yes	The Level Type. This is based on the MSD_LEVEL_TYPE lookup. The possible values for this are : 1. Top Level, 2. Bottom Level, and 3. Intermediate Level.
ATTRIBUTE1_CONTEXT	VARCHAR2	(240)		Context for the First Atrribute associated with this level.
ATTRIBUTE2_CONTEXT	VARCHAR2	(240)		Context for the Second Atrribute associated with this level.
ATTRIBUTE3_CONTEXT	VARCHAR2	(240)		Context for the Third Atrribute associated with this level.
ATTRIBUTE4_CONTEXT	VARCHAR2	(240)		Context for the Fourth Atrribute associated with this level.
ATTRIBUTE5_CONTEXT	VARCHAR2	(240)		Context for the Fifth Atrribute associated with this level.
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.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment.
ORG_RELATIONSHIP_VIEW	VARCHAR2	(30)		Organization Dimension Relationship view
PLAN_TYPE	VARCHAR2	(30)		Plan Type
SYSTEM_ATTRIBUTE1_CONTEXT	VARCHAR2	(240)		Context to distinguish level values in the same level based upon SYSTEM_ATTRIBUTE1
SYSTEM_ATTRIBUTE2_CONTEXT	VARCHAR2	(240)		Context to distinguish level values in the same level based upon SYSTEM_ATTRIBUTE2

Query Text

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


SELECT LEVEL_ID
,      LEVEL_NAME
,      DESCRIPTION
,      DIMENSION_CODE
,      LEVEL_TYPE_CODE
,      ATTRIBUTE1_CONTEXT
,      ATTRIBUTE2_CONTEXT
,      ATTRIBUTE3_CONTEXT
,      ATTRIBUTE4_CONTEXT
,      ATTRIBUTE5_CONTEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_RELATIONSHIP_VIEW
,      PLAN_TYPE
,      SYSTEM_ATTRIBUTE1_CONTEXT
,      SYSTEM_ATTRIBUTE2_CONTEXT
FROM MSD.MSD_LEVELS;

Dependencies

[top of page]

MSD.MSD_LEVELS does not reference any database object

MSD.MSD_LEVELS is referenced by following:

APPS: MSD_LEVELS