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


TABLE: APPLSYS.BISM_AGGREGATES

Object Details
Object Name: BISM_AGGREGATES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.BISM_AGGREGATES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BISM_AGGREGATES_PK
  1. ColumnCONTAINER_ID
  2. ColumnCONTAINEE_ID
  3. ColumnAGGREGATE_INFO
Indexes
Index Type Uniqueness Tablespace Column
BISM_AGGREGATES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTAINER_ID
ColumnCONTAINEE_ID
ColumnAGGREGATE_INFO
BISM_AGGREGATES_UK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTAINEE_ID
ColumnCONTAINER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
BISM_AGGREGATES SYS_C00140645 TableBISM_OBJECTS BISM_AGGREGATES CONTAINEE_ID
BISM_AGGREGATES SYS_C00140644 TableBISM_OBJECTS BISM_AGGREGATES CONTAINER_ID
Columns
Name Datatype Length Mandatory Comments
CONTAINER_ID RAW (16) Yes
CONTAINEE_ID RAW (16) Yes
AGGREGATE_INFO NUMBER (16) Yes
Query Text

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


SELECT CONTAINER_ID
,      CONTAINEE_ID
,      AGGREGATE_INFO
FROM APPLSYS.BISM_AGGREGATES;

Dependencies

[top of page]

APPLSYS.BISM_AGGREGATES does not reference any database object

APPLSYS.BISM_AGGREGATES is referenced by following:

SchemaAPPLSYS
ViewBISM_AGGREGATES#