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

TABLE: BSC.BSC_SYS_DIM_LEVEL_RELS

Object Details
Object Name: BSC_SYS_DIM_LEVEL_RELS
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_SYS_DIM_LEVEL_RELS
Subobject Name:
Status: VALID


BSC_SYS_DIM_LEVELS_RELS stores information about the relationships between dimension levels
such as dimension level identifier, parent dimension level identifier and realtionship type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_SYS_DIM_LEVEL_RELS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIM_LEVEL_ID
ColumnPARENT_DIM_LEVEL_ID
BSC_SYS_DIM_LEVEL_RELS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELATION_COL
Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Yes Dimension level identifier
RELATION_COL VARCHAR2 (50)
Relation field
PARENT_DIM_LEVEL_ID NUMBER (5) Yes Parent dimension level identifier
RELATION_TYPE NUMBER (15) Yes Relation Type, 1= 1xn, 2 = nxm
DIRECT_RELATION NUMBER (3)
Direct relationship flag
DATA_SOURCE_TYPE VARCHAR2 (30)
Data source type
DATA_SOURCE VARCHAR2 (240)
Data source
Query Text

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


SELECT DIM_LEVEL_ID
,      RELATION_COL
,      PARENT_DIM_LEVEL_ID
,      RELATION_TYPE
,      DIRECT_RELATION
,      DATA_SOURCE_TYPE
,      DATA_SOURCE
FROM BSC.BSC_SYS_DIM_LEVEL_RELS;

Dependencies

[top of page]

BSC.BSC_SYS_DIM_LEVEL_RELS does not reference any database object

BSC.BSC_SYS_DIM_LEVEL_RELS is referenced by following:

SchemaAPPS
SynonymBSC_SYS_DIM_LEVEL_RELS