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

TABLE: BSC.BSC_KPI_ANALYSIS_OPTIONS_TL

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


BSC_KPI_ANALYSIS_OPTIONS_TL stores translated information about analysis options. Each row includes the analysis option name and analysis option help.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_ANALYSIS_OPTIONS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnANALYSIS_GROUP_ID
ColumnOPTION_ID
ColumnPARENT_OPTION_ID
ColumnGRANDPARENT_OPTION_ID
ColumnLANGUAGE
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
LANGUAGE VARCHAR2 (4) Yes Language code
SOURCE_LANG VARCHAR2 (4) Yes The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Yes Analysis option name (Max 25 chars)
HELP VARCHAR2 (1024) Yes Analysis option help (Max 80 chars)
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
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      HELP
FROM BSC.BSC_KPI_ANALYSIS_OPTIONS_TL;

Dependencies

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL is referenced by following:

SchemaAPPS
SynonymBSC_KPI_ANALYSIS_OPTIONS_TL