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

TABLE: BSC.BSC_SYS_FILTERS

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


BSC_SYS_FILTERS stores information about filter definition such as dimension level identifier and dimension level value. The SOURCE_TYPE and SOURCE_CODE columns are used to define the filter level at System, Tab or indicator level. At this moment the filter is only at TAB level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_SYS_FILTERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_TYPE
ColumnSOURCE_CODE
ColumnDIM_LEVEL_ID
ColumnDIM_LEVEL_VALUE
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Yes Source type
SOURCE_CODE NUMBER (5) Yes Source code. Tab identifier or indicator code
DIM_LEVEL_ID NUMBER (5) Yes Dimension level identifier
DIM_LEVEL_VALUE VARCHAR2 (400) Yes Dimension level value
Query Text

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


SELECT SOURCE_TYPE
,      SOURCE_CODE
,      DIM_LEVEL_ID
,      DIM_LEVEL_VALUE
FROM BSC.BSC_SYS_FILTERS;

Dependencies

[top of page]

BSC.BSC_SYS_FILTERS does not reference any database object

BSC.BSC_SYS_FILTERS is referenced by following:

SchemaAPPS
SynonymBSC_SYS_FILTERS