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

TABLE: BSC.BSC_KPI_DIM_SETS_TL

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


BSC_KPI_DIM_SETS_TL stores translated information about dimension sets.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_DIM_SETS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnDIM_SET_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Indicator code
DIM_SET_ID NUMBER (3) Yes Dimension set 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 (60) Yes Dimension set name (Max 20 chars)
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SHORT_NAME VARCHAR2 (30)
Short name
Query Text

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


SELECT INDICATOR
,      DIM_SET_ID
,      LANGUAGE
,      SOURCE_LANG
,      NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SHORT_NAME
FROM BSC.BSC_KPI_DIM_SETS_TL;

Dependencies

[top of page]

BSC.BSC_KPI_DIM_SETS_TL does not reference any database object

BSC.BSC_KPI_DIM_SETS_TL is referenced by following:

SchemaAPPS
SynonymBSC_KPI_DIM_SETS_TL