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


TABLE: BSC.BSC_KPI_ANALYSIS_OPTIONS_B

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


BSC_KPI_ANALYSIS_OPTIONS_B stores information about analysis options by indicator. Each row includes values that identify a particular analysis option such as indicator code, analysis group , analysis option, dimension set and default value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_ANALYSIS_OPTIONS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnANALYSIS_GROUP_ID
ColumnOPTION_ID
ColumnPARENT_OPTION_ID
ColumnGRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDIM_SET_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Indicator code
ANALYSIS_GROUP_ID NUMBER (3) Yes Analysis group identifier
OPTION_ID NUMBER (3) Yes Analysis option identifier
PARENT_OPTION_ID NUMBER (3) Yes Analysis parent option identifier
GRANDPARENT_OPTION_ID NUMBER (3) Yes Analysis grand parent option identifier
DIM_SET_ID NUMBER (3) Yes Dimension set identifier
USER_LEVEL0 NUMBER (3)
Visibility status for design level 0
USER_LEVEL1 NUMBER (3)
Visibility status for design level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for design level 1
USER_LEVEL2 NUMBER (3)
Visibility status for design level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for design level 2
SHORT_NAME VARCHAR2 (30)
Short name
Query Text

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


SELECT INDICATOR
,      ANALYSIS_GROUP_ID
,      OPTION_ID
,      PARENT_OPTION_ID
,      GRANDPARENT_OPTION_ID
,      DIM_SET_ID
,      USER_LEVEL0
,      USER_LEVEL1
,      USER_LEVEL1_DEFAULT
,      USER_LEVEL2
,      USER_LEVEL2_DEFAULT
,      SHORT_NAME
FROM BSC.BSC_KPI_ANALYSIS_OPTIONS_B;

Dependencies

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_B does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_B is referenced by following:

SchemaAPPS
SynonymBSC_KPI_ANALYSIS_OPTIONS_B