[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_COM_DIM_LEVELS |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_COM_DIM_LEVELS |
Subobject Name: | |
Status: | VALID |
BSC_SYS_COM_DIM_LEVELS stores information about the common dimension levels by tab.
Each row includes values that identify the dimension level in the list button such as tab identifier,
dimension level index and identifier.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_COM_DIM_LEVELS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TAB_ID
DIM_LEVEL_INDEX |
BSC_SYS_COM_DIM_LEVELS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DIM_LEVEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAB_ID | NUMBER | (5) | Yes | Tab identifier |
DIM_LEVEL_INDEX | NUMBER | (3) | Yes | Dimension level index |
DIM_LEVEL_ID | NUMBER | (5) | Yes | Dimension level identifier |
PARENT_LEVEL_INDEX | NUMBER | (3) | Parent dimension level index | |
PARENT_DIM_LEVEL_ID | NUMBER | (5) | Parent dimension level identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TAB_ID
, DIM_LEVEL_INDEX
, DIM_LEVEL_ID
, PARENT_LEVEL_INDEX
, PARENT_DIM_LEVEL_ID
FROM BSC.BSC_SYS_COM_DIM_LEVELS;
BSC.BSC_SYS_COM_DIM_LEVELS does not reference any database object
BSC.BSC_SYS_COM_DIM_LEVELS is referenced by following:
|
|
|