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

TABLE: BSC.BSC_OLAP_OBJECT_RELATION

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_OLAP_OBJECT_RELATION_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_OBJECT
ColumnPARENT_OBJECT_TYPE
ColumnCONTEXT
BSC_OLAP_OBJECT_RELATION_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT
ColumnOBJECT_TYPE
ColumnCONTEXT
Columns
Name Datatype Length Mandatory Comments
PARENT_OBJECT VARCHAR2 (800)
PARENT_OBJECT_TYPE VARCHAR2 (100)
OBJECT VARCHAR2 (800)
OBJECT_TYPE VARCHAR2 (100)
CONTEXT VARCHAR2 (100)
RELATION_TYPE VARCHAR2 (100)
RELATION_OBJECT VARCHAR2 (400)
RELATION_OBJECT_TYPE VARCHAR2 (100)
PROPERTY1 VARCHAR2 (4000)
PROPERTY2 VARCHAR2 (4000)
PROPERTY3 VARCHAR2 (4000)
PROPERTY4 VARCHAR2 (4000)
PROPERTY5 VARCHAR2 (4000)
PROPERTY6 VARCHAR2 (4000)
PROPERTY7 VARCHAR2 (4000)
PROPERTY8 VARCHAR2 (4000)
PROPERTY9 VARCHAR2 (4000)
PROPERTY10 VARCHAR2 (4000)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT PARENT_OBJECT
,      PARENT_OBJECT_TYPE
,      OBJECT
,      OBJECT_TYPE
,      CONTEXT
,      RELATION_TYPE
,      RELATION_OBJECT
,      RELATION_OBJECT_TYPE
,      PROPERTY1
,      PROPERTY2
,      PROPERTY3
,      PROPERTY4
,      PROPERTY5
,      PROPERTY6
,      PROPERTY7
,      PROPERTY8
,      PROPERTY9
,      PROPERTY10
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BSC.BSC_OLAP_OBJECT_RELATION;

Dependencies

[top of page]

BSC.BSC_OLAP_OBJECT_RELATION does not reference any database object

BSC.BSC_OLAP_OBJECT_RELATION is referenced by following:

SchemaAPPS
SynonymBSC_OLAP_OBJECT_RELATION