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: BSC.BSC_KPI_DIM_LEVELS_B

Object Details

Object Name:	BSC_KPI_DIM_LEVELS_B
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_KPI_DIM_LEVELS_B
Subobject Name:
Status:	VALID

BSC_KPI_DIM_LEVELS_B stores information about dimension levels by indicator. Each row includes values that identify a particular dimension level such as indicator code, dimension set, dimension level, dimension table, dimension view, position, status and default value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_KPI_DIM_LEVELS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDICATOR DIM_SET_ID DIM_LEVEL_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
INDICATOR	NUMBER	(5)	Yes	Indicator code
DIM_SET_ID	NUMBER	(3)	Yes	Dimension set identifier
DIM_LEVEL_INDEX	NUMBER	(3)	Yes	Dimension level index
LEVEL_TABLE_NAME	VARCHAR2	(30)	Yes	Table name
LEVEL_VIEW_NAME	VARCHAR2	(30)		Table or filter view name
FILTER_COLUMN	VARCHAR2	(30)		The column to use for filter condition
FILTER_VALUE	NUMBER	(5)		The value to use for filter condition
DEFAULT_VALUE	VARCHAR2	(2)		Option Default : 'T'= by total, 'C'= by comparison
DEFAULT_TYPE	NUMBER	(5)		How to handle default_value when dimension set is changed
VALUE_ORDER_BY	NUMBER	(5)	Yes	Dimension level values order
COMP_ORDER_BY	NUMBER	(5)	Yes	Graph item order
LEVEL_PK_COL	VARCHAR2	(30)	Yes	Level primary key column
PARENT_LEVEL_INDEX	NUMBER	(3)		Parent level index
PARENT_LEVEL_REL	VARCHAR2	(30)		Parent level field
TABLE_RELATION	VARCHAR2	(30)		Relation mxn tabel name
PARENT_LEVEL_INDEX2	NUMBER	(3)		Second parent level index
PARENT_LEVEL_REL2	VARCHAR2	(30)		Second parent level field
STATUS	NUMBER	(3)	Yes	2= Normal, 0=Invisible, 1= Disable
PARENT_IN_TOTAL	NUMBER	(3)		Behavior when dimension parent is in TOTAL
POSITION	NUMBER	(3)	Yes	0= Normal, 1= top-corner, 2= hide
TOTAL0	NUMBER	(3)		If the code 0 in DB
LEVEL_DISPLAY	NUMBER	(3)		To disable other level index
NO_ITEMS	NUMBER	(1)		If there are not items the drill will be disabled
DEFAULT_KEY_VALUE	VARCHAR2	(400)		Default key value item
USER_LEVEL0	NUMBER	(3)		Visibility status for level 0
USER_LEVEL1	NUMBER	(3)		Visibility status for level 1
USER_LEVEL1_DEFAULT	NUMBER	(3)		Visibility default status for level 1
USER_LEVEL2	NUMBER	(3)		Visibility status for level 2
USER_LEVEL2_DEFAULT	NUMBER	(3)		Visibility default status for level 2
TARGET_LEVEL	NUMBER	(1)		Target Level

Query Text

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


SELECT INDICATOR
,      DIM_SET_ID
,      DIM_LEVEL_INDEX
,      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
,      TARGET_LEVEL
FROM BSC.BSC_KPI_DIM_LEVELS_B;

Dependencies

[top of page]

BSC.BSC_KPI_DIM_LEVELS_B does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_B is referenced by following:

APPS: BSC_KPI_DIM_LEVELS_B