[Home] [Help]
[Dependency Information]
| Object Name: | BSC_TAB_INDICATORS |
|---|---|
| Object Type: | TABLE |
| Owner: | BSC |
| FND Design Data: | BSC.BSC_TAB_INDICATORS
|
| Subobject Name: | |
| Status: | VALID |
BSC_TAB_INDICATOR stores information about relationships between tab and indicator besides some indicator properties for BSC model panel.
| Tablespace: | APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BSC_TAB_INDICATORS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
TAB_ID
INDICATOR
|
| BSC_TAB_INDICATORS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INDICATOR
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TAB_ID | NUMBER | (5) | Yes | Tab identifier |
| INDICATOR | NUMBER | (5) | Yes | Indicator code |
| BSC_MODEL_FLAG | NUMBER | (3) | BSC model flag | |
| LEFT_POSITION | NUMBER | (5) | Position -LEFT | |
| TOP_POSITION | NUMBER | (5) | Position -TOP | |
| WIDTH | NUMBER | (5) | Position -WITHD | |
| HEIGHT | NUMBER | (5) | Position -HEIGHT | |
| BACKCOLOR | NUMBER | (3) | Indicator panel color in BSC model |
Cut, paste (and edit) the following text to query this object:
SELECT TAB_ID
, INDICATOR
, BSC_MODEL_FLAG
, LEFT_POSITION
, TOP_POSITION
, WIDTH
, HEIGHT
, BACKCOLOR
FROM BSC.BSC_TAB_INDICATORS;
BSC.BSC_TAB_INDICATORS does not reference any database object
BSC.BSC_TAB_INDICATORS is referenced by following:
APPS
BSC_TAB_INDICATORS
|
|
|
|