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

VIEW: APPS.BSC_DIM_OBJ_CHD_RELS_VL

Object Details
Object Name: BSC_DIM_OBJ_CHD_RELS_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 child relationship


[View Source]

Columns
Name Datatype Length Mandatory Comments
SHORT_NAME VARCHAR2 (30)
Short name
DIM_OBJ_ID NUMBER (5) Yes Dimension level identifier
DIM_OBJ_NAME VARCHAR2 (255) Yes
CHILD_SHORT_NAME VARCHAR2 (30)
CHILD_DIM_OBJ_ID NUMBER (5) Yes Dimension level identifier
CHILD_DIM_OBJ_NAME VARCHAR2 (255) Yes
BIND_COLUMN VARCHAR2 (50)
RELATION_TYPE NUMBER (15) Yes Dimension level identifier
DIRECT_RELATION NUMBER (3)
Dimension level identifier
DATA_TYPE VARCHAR2 (30)
Data source type
DATA_SOURCE VARCHAR2 (240)
Data source
LEVEL_TABLE_NAME VARCHAR2 (30) Yes Dimension level table name
TABLE_TYPE NUMBER (3) Yes Table type, 0=normal, 1= system table
LEVEL_PK_COL VARCHAR2 (30) Yes Primary key column name
ABBREVIATION VARCHAR2 (24) Yes Abbreviation to generate dump values
LEVEL_VIEW_NAME VARCHAR2 (30)
Dimension level view name
SOURCE VARCHAR2 (10)
Source
LAST_UPDATE_DATE DATE

CHILD_LAST_UPDATE_DATE DATE

Query Text

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


SELECT SHORT_NAME
,      DIM_OBJ_ID
,      DIM_OBJ_NAME
,      CHILD_SHORT_NAME
,      CHILD_DIM_OBJ_ID
,      CHILD_DIM_OBJ_NAME
,      BIND_COLUMN
,      RELATION_TYPE
,      DIRECT_RELATION
,      DATA_TYPE
,      DATA_SOURCE
,      LEVEL_TABLE_NAME
,      TABLE_TYPE
,      LEVEL_PK_COL
,      ABBREVIATION
,      LEVEL_VIEW_NAME
,      SOURCE
,      LAST_UPDATE_DATE
,      CHILD_LAST_UPDATE_DATE
FROM APPS.BSC_DIM_OBJ_CHD_RELS_VL;

Dependencies

[top of page]

APPS.BSC_DIM_OBJ_CHD_RELS_VL references the following:

SchemaAPPS
ViewBSC_SYS_DIM_LEVELS_VL
SynonymBSC_SYS_DIM_LEVEL_RELS

APPS.BSC_DIM_OBJ_CHD_RELS_VL is not referenced by any database object