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.BISFV_DIMENSION_LEVELS

Object Details

Object Name:	BISFV_DIMENSION_LEVELS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIS.BISFV_DIMENSION_LEVELS
Subobject Name:
Status:	VALID

View Type

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

BISFV_DIMENSION_LEVELS is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_LEVELS.
Full views are used as a one-stop template for building up ad-hoc queries.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_LEVEL_ID	NUMBER		Yes	Target Level ID Column
DIMENSION_LEVEL_SHORT_NAME	VARCHAR2	(30)	Yes	Target Level Short Name
DIMENSION_LEVEL_NAME	VARCHAR2	(255)	Yes	Target Level Name
DESCRIPTION	VARCHAR2	(1024)		Target Level Description
DIMENSION_ID	NUMBER		Yes	Dimension ID
DIMENSION_SHORT_NAME	VARCHAR2	(30)	Yes	Dimension Short Name
DIMENSION_NAME	VARCHAR2	(255)	Yes	Dimensions Name
LEVEL_VALUES_VIEW_NAME	VARCHAR2	(30)		View associated to the Level. This view provides the data from the source system for the level.
WHERE_CLAUSE	VARCHAR2	(2000)		No Longer Used
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SOURCE	VARCHAR2	(30)	Yes	Source system type for the dimension level, such as OLTP or EDW.
COMPARISON_LABEL_CODE	VARCHAR2	(30)		Comparison Label Code
ATTRIBUTE_CODE	VARCHAR2	(30)		Attribute Code
APPLICATION_ID	NUMBER			Application Id
VIEW_OBJECT_NAME	VARCHAR2	(255)		View Object Name
DEFAULT_VALUES_API	VARCHAR2	(255)		Default Values API
DEFAULT_SEARCH	VARCHAR2	(480)		Default Search
LONG_LOV	VARCHAR2	(1)		Long LOV
MASTER_LEVEL	VARCHAR2	(30)		Master Level
ENABLED	VARCHAR2	(1)		Enabled , T or F
DRILL_TO_FORM_FUNCTION	VARCHAR2	(480)		Drill To Form Function
HIDE_IN_DESIGN	VARCHAR2	(1)		Flag to indicate whether the dimension is hidden in all designers.

Query Text

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


SELECT DIMENSION_LEVEL_ID
,      DIMENSION_LEVEL_SHORT_NAME
,      DIMENSION_LEVEL_NAME
,      DESCRIPTION
,      DIMENSION_ID
,      DIMENSION_SHORT_NAME
,      DIMENSION_NAME
,      LEVEL_VALUES_VIEW_NAME
,      WHERE_CLAUSE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE
,      COMPARISON_LABEL_CODE
,      ATTRIBUTE_CODE
,      APPLICATION_ID
,      VIEW_OBJECT_NAME
,      DEFAULT_VALUES_API
,      DEFAULT_SEARCH
,      LONG_LOV
,      MASTER_LEVEL
,      ENABLED
,      DRILL_TO_FORM_FUNCTION
,      HIDE_IN_DESIGN
FROM APPS.BISFV_DIMENSION_LEVELS;

Dependencies

[top of page]

APPS.BISFV_DIMENSION_LEVELS references the following:

APPS: BIS_DIMENSIONS; BIS_DIMENSIONS_TL; BIS_LEVELS; BIS_LEVELS_TL

APPS.BISFV_DIMENSION_LEVELS is referenced by following:

APPS: BIS_COMPUTED_ACTUAL_PVT - show dependent code; BIS_DIMENSION_LEVEL_PVT - show dependent code; BIS_INTERMEDIATE_LOV_PVT - show dependent code; BIS_UTILITIES_PUB - show dependent code; BIS_UTILITIES_PVT - show dependent code; BSC_BIS_DIM_OBJ_PUB - show dependent code; BSC_PMF_UI_API_PUB - show dependent code