[Home] [Help] [Dependency Information]
Object Name: | BSC_KPI_DIM_LEVELS_B |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_KPI_DIM_LEVELS_B |
Subobject Name: | |
Status: | VALID |
BSC_KPI_DIM_LEVELS_B stores information about dimension levels by indicator. Each row includes values that identify a particular dimension level such as indicator code, dimension set, dimension level, dimension table, dimension view, position, status and default value.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_KPI_DIM_LEVELS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INDICATOR
DIM_SET_ID DIM_LEVEL_INDEX |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDICATOR | NUMBER | (5) | Yes | Indicator code |
DIM_SET_ID | NUMBER | (3) | Yes | Dimension set identifier |
DIM_LEVEL_INDEX | NUMBER | (3) | Yes | Dimension level index |
LEVEL_TABLE_NAME | VARCHAR2 | (30) | Yes | Table name |
LEVEL_VIEW_NAME | VARCHAR2 | (30) | Table or filter view name | |
FILTER_COLUMN | VARCHAR2 | (30) | The column to use for filter condition | |
FILTER_VALUE | NUMBER | (5) | The value to use for filter condition | |
DEFAULT_VALUE | VARCHAR2 | (2) | Option Default : 'T'= by total, 'C'= by comparison | |
DEFAULT_TYPE | NUMBER | (5) | How to handle default_value when dimension set is changed | |
VALUE_ORDER_BY | NUMBER | (5) | Yes | Dimension level values order |
COMP_ORDER_BY | NUMBER | (5) | Yes | Graph item order |
LEVEL_PK_COL | VARCHAR2 | (30) | Yes | Level primary key column |
PARENT_LEVEL_INDEX | NUMBER | (3) | Parent level index | |
PARENT_LEVEL_REL | VARCHAR2 | (30) | Parent level field | |
TABLE_RELATION | VARCHAR2 | (30) | Relation mxn tabel name | |
PARENT_LEVEL_INDEX2 | NUMBER | (3) | Second parent level index | |
PARENT_LEVEL_REL2 | VARCHAR2 | (30) | Second parent level field | |
STATUS | NUMBER | (3) | Yes | 2= Normal, 0=Invisible, 1= Disable |
PARENT_IN_TOTAL | NUMBER | (3) | Behavior when dimension parent is in TOTAL | |
POSITION | NUMBER | (3) | Yes | 0= Normal, 1= top-corner, 2= hide |
TOTAL0 | NUMBER | (3) | If the code 0 in DB | |
LEVEL_DISPLAY | NUMBER | (3) | To disable other level index | |
NO_ITEMS | NUMBER | (1) | If there are not items the drill will be disabled | |
DEFAULT_KEY_VALUE | VARCHAR2 | (400) | Default key value item | |
USER_LEVEL0 | NUMBER | (3) | Visibility status for level 0 | |
USER_LEVEL1 | NUMBER | (3) | Visibility status for level 1 | |
USER_LEVEL1_DEFAULT | NUMBER | (3) | Visibility default status for level 1 | |
USER_LEVEL2 | NUMBER | (3) | Visibility status for level 2 | |
USER_LEVEL2_DEFAULT | NUMBER | (3) | Visibility default status for level 2 | |
TARGET_LEVEL | NUMBER | (1) | Target Level |
Cut, paste (and edit) the following text to query this object:
SELECT INDICATOR
, DIM_SET_ID
, DIM_LEVEL_INDEX
, LEVEL_TABLE_NAME
, LEVEL_VIEW_NAME
, FILTER_COLUMN
, FILTER_VALUE
, DEFAULT_VALUE
, DEFAULT_TYPE
, VALUE_ORDER_BY
, COMP_ORDER_BY
, LEVEL_PK_COL
, PARENT_LEVEL_INDEX
, PARENT_LEVEL_REL
, TABLE_RELATION
, PARENT_LEVEL_INDEX2
, PARENT_LEVEL_REL2
, STATUS
, PARENT_IN_TOTAL
, POSITION
, TOTAL0
, LEVEL_DISPLAY
, NO_ITEMS
, DEFAULT_KEY_VALUE
, USER_LEVEL0
, USER_LEVEL1
, USER_LEVEL1_DEFAULT
, USER_LEVEL2
, USER_LEVEL2_DEFAULT
, TARGET_LEVEL
FROM BSC.BSC_KPI_DIM_LEVELS_B;
BSC.BSC_KPI_DIM_LEVELS_B does not reference any database object
BSC.BSC_KPI_DIM_LEVELS_B is referenced by following:
|
|
|