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

TABLE: BSC.BSC_TABS_B

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


BSC_TABS_B stores information about tab such as tab identifier, indicator model flag, default model and zoom factor.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_TABS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAB_ID
BSC_TABS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHORT_NAME
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Yes Tab identifier
KPI_MODEL NUMBER (1)
Indicator Group model flag
BSC_MODEL NUMBER (1)
BSC model flag
CROSS_MODEL NUMBER (1)
Cross model flag
DEFAULT_MODEL NUMBER (15)
Default model
ZOOM_FACTOR NUMBER

Zoom factor for BSC model
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAB_INDEX NUMBER (5)
Tab Index
PARENT_TAB_ID NUMBER (5)
Parent Tab identifier
OWNER_ID NUMBER (15)
Owner id
SHORT_NAME VARCHAR2 (30)
Short name
Query Text

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


SELECT TAB_ID
,      KPI_MODEL
,      BSC_MODEL
,      CROSS_MODEL
,      DEFAULT_MODEL
,      ZOOM_FACTOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TAB_INDEX
,      PARENT_TAB_ID
,      OWNER_ID
,      SHORT_NAME
FROM BSC.BSC_TABS_B;

Dependencies

[top of page]

BSC.BSC_TABS_B does not reference any database object

BSC.BSC_TABS_B is referenced by following:

SchemaAPPS
SynonymBSC_TABS_B