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

TABLE: BIS.EDW_LEVEL_RELATIONS_MD

Object Details
Object Name: EDW_LEVEL_RELATIONS_MD
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_LEVEL_RELATIONS_MD
Subobject Name:
Status: VALID


EDW_LEVEL_RELATIONS_MD


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_LEVEL_RELATIONS_MD_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIM_ID
EDW_LEVEL_RELATIONS_MD_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHIER_ID
Columns
Name Datatype Length Mandatory Comments
LEVEL_RELATION_ID NUMBER (9)
comment
DIM_ID NUMBER (9)
comment
DIM_NAME VARCHAR2 (255)
comment
HIER_ID NUMBER (9)
comment
HIER_NAME VARCHAR2 (255)
comment
PARENT_LVL_ID NUMBER (9)
comment
PARENT_LVL_NAME VARCHAR2 (255)
comment
PARENT_LVL_PREFIX VARCHAR2 (255)
comment
PARENT_LVLTBL_ID NUMBER

comment
PARENT_LVLTBL_NAME VARCHAR2 (259)
comment
UK_ID NUMBER

comment
UK_NAME VARCHAR2 (255)
comment
CHILD_LVL_ID NUMBER (9)
comment
CHILD_LVL_NAME VARCHAR2 (255)
comment
CHILD_LVL_PREFIX VARCHAR2 (255)
comment
CHILD_LVLTBL_ID NUMBER

comment
CHIL_LVLTBL_NAME VARCHAR2 (259)
comment
FK_ID NUMBER

comment
FK_NAME VARCHAR2 (255)
comment
Query Text

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


SELECT LEVEL_RELATION_ID
,      DIM_ID
,      DIM_NAME
,      HIER_ID
,      HIER_NAME
,      PARENT_LVL_ID
,      PARENT_LVL_NAME
,      PARENT_LVL_PREFIX
,      PARENT_LVLTBL_ID
,      PARENT_LVLTBL_NAME
,      UK_ID
,      UK_NAME
,      CHILD_LVL_ID
,      CHILD_LVL_NAME
,      CHILD_LVL_PREFIX
,      CHILD_LVLTBL_ID
,      CHIL_LVLTBL_NAME
,      FK_ID
,      FK_NAME
FROM BIS.EDW_LEVEL_RELATIONS_MD;

Dependencies

[top of page]

BIS.EDW_LEVEL_RELATIONS_MD does not reference any database object

BIS.EDW_LEVEL_RELATIONS_MD is referenced by following:

SchemaAPPS
SynonymEDW_LEVEL_RELATIONS_MD