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_BIS_DIM_OBJS_VL

Object Details

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

View Type

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

View of the BIS/BSC dimension object for PMD

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SHORT_NAME	VARCHAR2	(30)		Short name
BIS_DIM_OBJ_ID	NUMBER		Yes	Dimension level identifier
BSC_DIM_OBJ_ID	NUMBER	(5)	Yes	Dimension level identifier
APPLICATION_ID	NUMBER			Dimension level identifier
DIM_OBJ_VIEW_NAME	VARCHAR2	(30)		Dimension level view name
WHERE_CLAUSE	VARCHAR2	(2000)		Dimension level view name
NAME	VARCHAR2	(255)	Yes
DESCRIPTION	VARCHAR2	(1024)	Yes
SOURCE_TYPE	VARCHAR2	(30)	Yes	Data source type
DATA_SOURCE	VARCHAR2	(10)		Data source
COMPARISON_LABEL_CODE	VARCHAR2	(30)
TOTAL_DISP_NAME	VARCHAR2	(45)
COMP_DISP_NAME	VARCHAR2	(45)
DIM_OBJ_TABLE_NAME	VARCHAR2	(30)	Yes	Dimension level table name
TABLE_TYPE	NUMBER	(3)	Yes	Table type, 0=normal, 1= system table
DIM_OBJ_PK_COL	VARCHAR2	(30)	Yes	Primary key column name
ABBREVIATION	VARCHAR2	(24)	Yes	Abbreviation to generate dump values
VALUE_ORDER_BY	NUMBER	(5)	Yes	Dimension level identifier
COMP_ORDER_BY	NUMBER	(5)	Yes	Dimension level identifier
EDW_FLAG	NUMBER
CUSTOM_GROUP	NUMBER	(5)	Yes	Dimension level identifier
USER_KEY_SIZE	NUMBER	(3)	Yes
DISP_KEY_SIZE	NUMBER	(5)	Yes
EDW_DIM_ID	NUMBER
EDW_DIM_DIM_OBJ_ID	NUMBER
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
MASTER_LEVEL	VARCHAR2	(30)		Master Level
LONG_LOV	VARCHAR2	(1)		Long LOV
DEFAULT_SEARCH	VARCHAR2	(480)		Default search
ENABLED	VARCHAR2	(1)		Enabled Flag
DRILL_TO_FORM_FUNCTION	VARCHAR2	(480)
HIDE_IN_DESIGN	VARCHAR2	(1)

Query Text

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


SELECT SHORT_NAME
,      BIS_DIM_OBJ_ID
,      BSC_DIM_OBJ_ID
,      APPLICATION_ID
,      DIM_OBJ_VIEW_NAME
,      WHERE_CLAUSE
,      NAME
,      DESCRIPTION
,      SOURCE_TYPE
,      DATA_SOURCE
,      COMPARISON_LABEL_CODE
,      TOTAL_DISP_NAME
,      COMP_DISP_NAME
,      DIM_OBJ_TABLE_NAME
,      TABLE_TYPE
,      DIM_OBJ_PK_COL
,      ABBREVIATION
,      VALUE_ORDER_BY
,      COMP_ORDER_BY
,      EDW_FLAG
,      CUSTOM_GROUP
,      USER_KEY_SIZE
,      DISP_KEY_SIZE
,      EDW_DIM_ID
,      EDW_DIM_DIM_OBJ_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MASTER_LEVEL
,      LONG_LOV
,      DEFAULT_SEARCH
,      ENABLED
,      DRILL_TO_FORM_FUNCTION
,      HIDE_IN_DESIGN
FROM APPS.BSC_BIS_DIM_OBJS_VL;

Dependencies

[top of page]

APPS.BSC_BIS_DIM_OBJS_VL references the following:

APPS: BIS_LEVELS_VL; BSC_SYS_DIM_LEVELS_VL

APPS.BSC_BIS_DIM_OBJS_VL is referenced by following:

APPS: BSC_BIS_DIMENSION_PUB - show dependent code; BSC_BIS_DIM_OBJ_PUB - show dependent code