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

TABLE: BSC.BSC_OLAP_OBJECT

Object Details
Object Name: BSC_OLAP_OBJECT
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_OLAP_OBJECT
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_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT
ColumnOBJECT_TYPE
ColumnCONTEXT
BSC_OLAP_OBJECT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_OBJECT
ColumnPARENT_OBJECT_TYPE
ColumnCONTEXT
Columns
Name Datatype Length Mandatory Comments
OBJECT VARCHAR2 (800)
OBJECT_TYPE VARCHAR2 (100)
CONTEXT VARCHAR2 (100)
PARENT_OBJECT VARCHAR2 (800)
PARENT_OBJECT_TYPE VARCHAR2 (100)
OLAP_OBJECT VARCHAR2 (400)
OLAP_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)
OPERATION_FLAG VARCHAR2 (40)
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 OBJECT
,      OBJECT_TYPE
,      CONTEXT
,      PARENT_OBJECT
,      PARENT_OBJECT_TYPE
,      OLAP_OBJECT
,      OLAP_OBJECT_TYPE
,      PROPERTY1
,      PROPERTY2
,      PROPERTY3
,      PROPERTY4
,      PROPERTY5
,      PROPERTY6
,      PROPERTY7
,      PROPERTY8
,      PROPERTY9
,      PROPERTY10
,      OPERATION_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BSC.BSC_OLAP_OBJECT;

Dependencies

[top of page]

BSC.BSC_OLAP_OBJECT does not reference any database object

BSC.BSC_OLAP_OBJECT is referenced by following:

SchemaAPPS
SynonymBSC_OLAP_OBJECT