Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BSC_BIS_DIM_OBJ_BY_DIM_VL

Object Details
Object Name: BSC_BIS_DIM_OBJ_BY_DIM_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View of Dimension object by Dimension


[View Source]

Columns
Name Datatype Length Mandatory Comments
DIM_SHORT_NAME VARCHAR2 (30)
Short name
DIM_ID NUMBER (5) Yes Dimension level identifier
DIM_NAME VARCHAR2 (255) Yes
OBJ_SHORT_NAME VARCHAR2 (30)
OBJ_ID NUMBER (5) Yes Dimension level identifier
OBJ_NAME VARCHAR2 (255) Yes
TOTAL_FLAG NUMBER (1) Yes
COMPARISON_FLAG NUMBER (1) Yes Dimension level identifier
FILTER_COLUMN VARCHAR2 (30)
Data source type
FILTER_VALUE NUMBER

Data source
DEFAULT_VALUE VARCHAR2 (2)
Dimension level table name
DEFAULT_TYPE NUMBER (5)
Table type, 0=normal, 1= system table
PARENT_IN_TOTAL NUMBER (3)
Primary key column name
NO_ITEMS NUMBER (1)
Dimension level view name
SOURCE VARCHAR2 (10)
Source
DIM_LAST_UPDATE_DATE DATE

DIM_OBJ_LAST_UPDATE_DATE DATE

WHERE_CLAUSE VARCHAR2 (4000)
where clause statement
Query Text

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


SELECT DIM_SHORT_NAME
,      DIM_ID
,      DIM_NAME
,      OBJ_SHORT_NAME
,      OBJ_ID
,      OBJ_NAME
,      TOTAL_FLAG
,      COMPARISON_FLAG
,      FILTER_COLUMN
,      FILTER_VALUE
,      DEFAULT_VALUE
,      DEFAULT_TYPE
,      PARENT_IN_TOTAL
,      NO_ITEMS
,      SOURCE
,      DIM_LAST_UPDATE_DATE
,      DIM_OBJ_LAST_UPDATE_DATE
,      WHERE_CLAUSE
FROM APPS.BSC_BIS_DIM_OBJ_BY_DIM_VL;

Dependencies

[top of page]

APPS.BSC_BIS_DIM_OBJ_BY_DIM_VL references the following:

SchemaAPPS
SynonymBSC_SYS_DIM_GROUPS_TL
SynonymBSC_SYS_DIM_LEVELS_BY_GROUP
ViewBSC_SYS_DIM_LEVELS_VL
APPS.BSC_BIS_DIM_OBJ_BY_DIM_VL is referenced by following:

SchemaAPPS
Package BodyBIS_DIMENSION_PUB - show dependent code
Package BodyBSC_BIS_DIMENSION_PUB - show dependent code
Package BodyBSC_CALENDAR_PUB - show dependent code