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]

VIEW: APPS.MSD_LEVELS_V

Object Details

Object Name:	MSD_LEVELS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_LEVELS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides the Levels, their Owning Dimension. It also specifies the Level Type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Underlying row identifier for a form. Not important for the Express server.
LEVEL_ID	NUMBER		Yes	Level ID.
LEVEL_NAME	VARCHAR2	(30)	Yes	Level name.
DESCRIPTION	VARCHAR2	(240)	Yes	Level description.
OWNING_DIMENSION_CODE	VARCHAR2	(3)	Yes	Code for the dimension to which that particular hierarchy belongs.
OWNING_DIMENSION	VARCHAR2	(80)	Yes	Description for the dimension to which that particular hierarchy belongs.
LEVEL_TYPE_CODE	VARCHAR2	(1)	Yes	Level type. The possible values are- 1. Top, 2. Bottom, 3. Internediate.
LEVEL_TYPE	VARCHAR2	(80)	Yes	Level type description.
ATTRIBUTE1_CONTEXT	VARCHAR2	(240)		Context of the first attribute for this level.
ATTRIBUTE2_CONTEXT	VARCHAR2	(240)		Context of the second attribute for this level.
ATTRIBUTE3_CONTEXT	VARCHAR2	(240)		Context of the third attribute for this level.
ATTRIBUTE4_CONTEXT	VARCHAR2	(240)		Context of the fourth attribute for this level.
ATTRIBUTE5_CONTEXT	VARCHAR2	(240)		Context of the fifth attribute for 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
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 ROW_ID
,      LEVEL_ID
,      LEVEL_NAME
,      DESCRIPTION
,      OWNING_DIMENSION_CODE
,      OWNING_DIMENSION
,      LEVEL_TYPE_CODE
,      LEVEL_TYPE
,      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
,      SYSTEM_ATTRIBUTE1_CONTEXT
,      SYSTEM_ATTRIBUTE2_CONTEXT
FROM APPS.MSD_LEVELS_V;

Dependencies

[top of page]

APPS.MSD_LEVELS_V references the following:

APPS: FND_LOOKUP_VALUES_VL; MSD_LEVELS

APPS.MSD_LEVELS_V is referenced by following:

APPS: MSD_CS_DFN_UTL - show dependent code; MSD_HIERARCHY_LEVELS_V