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_TMP_OPT_UI_LEVELS

Object Details

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

BSC TMP OPT UI LEVELS

Temporary Table Details

BSC.BSC_TMP_OPT_UI_LEVELS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
INDICATOR	NUMBER		Indicator
DIM_SET_ID	NUMBER		Dim set Id
DIM_DISPLAY_ORDER	NUMBER		Dimension display order
LEVEL_DISPLAY_ORDER	NUMBER		Level display order
LEVEL_TABLE_NAME	VARCHAR2	(100)	Level table name
LEVEL_DISPLAY_NAME	VARCHAR2	(300)	Level Display name
TARGET_LEVEL	NUMBER		Target Level

Query Text

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


SELECT INDICATOR
,      DIM_SET_ID
,      DIM_DISPLAY_ORDER
,      LEVEL_DISPLAY_ORDER
,      LEVEL_TABLE_NAME
,      LEVEL_DISPLAY_NAME
,      TARGET_LEVEL
FROM BSC.BSC_TMP_OPT_UI_LEVELS;

Dependencies

[top of page]

BSC.BSC_TMP_OPT_UI_LEVELS does not reference any database object

BSC.BSC_TMP_OPT_UI_LEVELS is referenced by following:

APPS: BSC_TMP_OPT_UI_LEVELS