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

VIEW: APPS.BSC_DIM_OBJ_PAR_RELS_VL

Object Details
Object Name: BSC_DIM_OBJ_PAR_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 parent 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
PARENT_SHORT_NAME VARCHAR2 (30)
PARENT_DIM_OBJ_ID NUMBER (5) Yes Dimension level identifier
PARENT_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

PARENT_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
,      PARENT_SHORT_NAME
,      PARENT_DIM_OBJ_ID
,      PARENT_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
,      PARENT_LAST_UPDATE_DATE
FROM APPS.BSC_DIM_OBJ_PAR_RELS_VL;

Dependencies

[top of page]

APPS.BSC_DIM_OBJ_PAR_RELS_VL references the following:

SchemaAPPS
ViewBSC_SYS_DIM_LEVELS_VL
SynonymBSC_SYS_DIM_LEVEL_RELS

APPS.BSC_DIM_OBJ_PAR_RELS_VL is not referenced by any database object