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

Object Details

Object Name:	BSC_KPI_DIM_LEVELS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BSC.BSC_KPI_DIM_LEVELS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_DIM_LEVELS_VL is a view that joins the translated, language specific values from BSC_KPI_DIM_LEVELS_TL with the non-displayed data from BSC_KPI_DIM_LEVELS_B . BSC uses this view to display translated information in languages installed at your site.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INDICATOR	NUMBER	(5)	Yes
DIM_SET_ID	NUMBER	(3)	Yes
DIM_LEVEL_INDEX	NUMBER	(3)	Yes
NAME	VARCHAR2	(255)	Yes
HELP	VARCHAR2	(1024)	Yes
TOTAL_DISP_NAME	VARCHAR2	(45)
COMP_DISP_NAME	VARCHAR2	(45)
LEVEL_TABLE_NAME	VARCHAR2	(30)	Yes
LEVEL_VIEW_NAME	VARCHAR2	(30)
FILTER_COLUMN	VARCHAR2	(30)
FILTER_VALUE	NUMBER	(5)
DEFAULT_VALUE	VARCHAR2	(2)
DEFAULT_TYPE	NUMBER	(5)
VALUE_ORDER_BY	NUMBER	(5)	Yes
COMP_ORDER_BY	NUMBER	(5)	Yes
LEVEL_PK_COL	VARCHAR2	(30)	Yes
PARENT_LEVEL_INDEX	NUMBER	(3)
PARENT_LEVEL_REL	VARCHAR2	(30)
TABLE_RELATION	VARCHAR2	(30)
PARENT_LEVEL_INDEX2	NUMBER	(3)
PARENT_LEVEL_REL2	VARCHAR2	(30)
STATUS	NUMBER	(3)	Yes
PARENT_IN_TOTAL	NUMBER	(3)
POSITION	NUMBER	(3)	Yes
TOTAL0	NUMBER	(3)
LEVEL_DISPLAY	NUMBER	(3)
NO_ITEMS	NUMBER	(1)
DEFAULT_KEY_VALUE	VARCHAR2	(400)
USER_LEVEL0	NUMBER	(3)
USER_LEVEL1	NUMBER	(3)
USER_LEVEL1_DEFAULT	NUMBER	(3)
USER_LEVEL2	NUMBER	(3)
USER_LEVEL2_DEFAULT	NUMBER	(3)
DISP_KEY_SIZE	NUMBER	(5)
TARGET_LEVEL	NUMBER	(1)		Target Level
LEVEL_SHORTNAME	VARCHAR2	(30)		Short name
LEVEL_SOURCE	VARCHAR2	(10)		Source

Query Text

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


SELECT INDICATOR
,      DIM_SET_ID
,      DIM_LEVEL_INDEX
,      NAME
,      HELP
,      TOTAL_DISP_NAME
,      COMP_DISP_NAME
,      LEVEL_TABLE_NAME
,      LEVEL_VIEW_NAME
,      FILTER_COLUMN
,      FILTER_VALUE
,      DEFAULT_VALUE
,      DEFAULT_TYPE
,      VALUE_ORDER_BY
,      COMP_ORDER_BY
,      LEVEL_PK_COL
,      PARENT_LEVEL_INDEX
,      PARENT_LEVEL_REL
,      TABLE_RELATION
,      PARENT_LEVEL_INDEX2
,      PARENT_LEVEL_REL2
,      STATUS
,      PARENT_IN_TOTAL
,      POSITION
,      TOTAL0
,      LEVEL_DISPLAY
,      NO_ITEMS
,      DEFAULT_KEY_VALUE
,      USER_LEVEL0
,      USER_LEVEL1
,      USER_LEVEL1_DEFAULT
,      USER_LEVEL2
,      USER_LEVEL2_DEFAULT
,      DISP_KEY_SIZE
,      TARGET_LEVEL
,      LEVEL_SHORTNAME
,      LEVEL_SOURCE
FROM APPS.BSC_KPI_DIM_LEVELS_VL;

Dependencies

[top of page]

APPS.BSC_KPI_DIM_LEVELS_VL references the following:

APPS: BSC_KPI_DIM_LEVELS_B; BSC_KPI_DIM_LEVELS_TL; BSC_SYS_DIM_LEVELS_B

APPS.BSC_KPI_DIM_LEVELS_VL is referenced by following:

APPS: BIS_PMF_GET_DIMLEVELS_PVT - show dependent code; BSC_BIS_DIMENSION_PUB - show dependent code; BSC_BIS_DIM_OBJ_PUB - show dependent code; BSC_BIS_DIM_REL_PUB - show dependent code; BSC_BIS_KPI_CRUD_PUB - show dependent code; BSC_BIS_KPI_MEAS_PUB - show dependent code; BSC_COMMON_DIM_LEVELS_PUB - show dependent code; BSC_DB_COLOR_KPI_V; BSC_DEFAULT_KEY_ITEM_PUB - show dependent code; BSC_DESIGNER_PVT - show dependent code; BSC_DIMENSION_SETS_PUB - show dependent code; BSC_DIM_LEVEL_FILTERS_PUB - show dependent code; BSC_KPI_DIM_SETS_PKG - show dependent code; BSC_METADATA_DESC - show dependent code; BSC_MO_UI_PKG - show dependent code; BSC_UPDATE_UTIL - show dependent code; BSC_UTILITY - show dependent code