[Home] [Help]
[Dependency Information]
| Object Name: | BSC_KPIS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BSC.BSC_KPIS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
BSC_KPIS_VL is a view that joins the translated, language specific values from BSC_KPIS_TL with the non-displayed data from BSC_KPIS_B . BSC uses this view to display translated information in languages installed at your site.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INDICATOR | NUMBER | (5) | Yes | |
| NAME | VARCHAR2 | (150) | Yes | |
| HELP | VARCHAR2 | (150) | Yes | |
| CSF_ID | NUMBER | (3) | Yes | |
| IND_GROUP_ID | NUMBER | (5) | Yes | |
| DISP_ORDER | NUMBER | (3) | Yes | |
| PROTOTYPE_FLAG | NUMBER | (3) | Yes | |
| INDICATOR_TYPE | NUMBER | (3) | Yes | |
| CONFIG_TYPE | NUMBER | (3) | Yes | |
| PERIODICITY_ID | NUMBER | (5) | Yes | |
| BM_GROUP_ID | NUMBER | (3) | Yes | |
| APPLY_COLOR_FLAG | NUMBER | (3) | Yes | |
| PROTOTYPE_COLOR | VARCHAR2 | (1) | ||
| SHARE_FLAG | NUMBER | (3) | Yes | |
| SOURCE_INDICATOR | NUMBER | (5) | ||
| PUBLISH_FLAG | NUMBER | |||
| EDW_FLAG | NUMBER | (1) | ||
| CALENDAR_ID | NUMBER | |||
| FISCAL_YEAR | NUMBER | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| SHORT_NAME | VARCHAR2 | (30) | Short name | |
| PROTOTYPE_COLOR_ID | NUMBER | (8) | Prototype Color for the Objective | |
| COLOR_ROLLUP_TYPE | VARCHAR2 | (30) | Defines the rollup type for the Objective from the underlying KPI Measures. Valid values are: WORST, BEST, MOST_FREQUENT, WEIGHTED_AVERAGE, DEFAULT_KPI | |
| WEIGHTED_COLOR_METHOD | NUMBER | Color Method for Weighted Average calculations for the Objective. Can be either: 1- INCREASING_GOOD 2- DECREASING_GOOD 3- WITHIN_RANGE 4 - FLEXIBLE | ||
| PROTOTYPE_TREND_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INDICATOR
, NAME
, HELP
, CSF_ID
, IND_GROUP_ID
, DISP_ORDER
, PROTOTYPE_FLAG
, INDICATOR_TYPE
, CONFIG_TYPE
, PERIODICITY_ID
, BM_GROUP_ID
, APPLY_COLOR_FLAG
, PROTOTYPE_COLOR
, SHARE_FLAG
, SOURCE_INDICATOR
, PUBLISH_FLAG
, EDW_FLAG
, CALENDAR_ID
, FISCAL_YEAR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SHORT_NAME
, PROTOTYPE_COLOR_ID
, COLOR_ROLLUP_TYPE
, WEIGHTED_COLOR_METHOD
, PROTOTYPE_TREND_ID
FROM APPS.BSC_KPIS_VL;
APPS
BSC_KPIS_B
BSC_KPIS_TL
BSC_SYS_CALENDARS_B
APPS
BSC_ANALYSIS_OPTION_PUB
- show dependent code
BSC_ANALYSIS_OPTION_PVT
- show dependent code
BSC_BIS_DIMENSION_PUB
- show dependent code
BSC_BIS_DIM_OBJ_PUB
- show dependent code
BSC_BIS_DIM_REL_PUB
- show dependent code
BSC_BIS_KPI_CRUD_PUB
- show dependent code
BSC_BIS_KPI_MEAS_PUB
- show dependent code
BSC_BIS_MEASURE_PUB
- show dependent code
BSC_BSC_ADAPTER
- show dependent code
BSC_CALENDAR_PUB
- show dependent code
BSC_COPY_INDICATOR_PUB
- show dependent code
BSC_DATASETS_PVT
- show dependent code
BSC_DBGEN_BSC_READER
- show dependent code
BSC_DBGEN_METADATA_READER
- show dependent code
BSC_DBGEN_UTILS
- show dependent code
BSC_DEFAULT_KEY_ITEM_PUB
- show dependent code
BSC_DESIGNER_PVT
- show dependent code
BSC_KPI_PVT
- show dependent code
BSC_METADATA_DESC
- show dependent code
BSC_METADATA_OPTIMIZER_PKG
- show dependent code
BSC_METADATA_OPTIMIZER_PKG
- show dependent code
BSC_MIGREATION_UI
- show dependent code
BSC_MO_DOC_PKG
- show dependent code
BSC_MO_HELPER_PKG
- show dependent code
BSC_MO_INDICATOR_PKG
- show dependent code
BSC_MO_UI_PKG
- show dependent code
BSC_OBJECTIVE_METADATA_SETUP
- show dependent code
BSC_PERIODICITIES_PUB
- show dependent code
BSC_PMF_UI_WRAPPER
- show dependent code
BSC_SIMULATION_VIEW_PUB
- show dependent code
BSC_SIMULATION_VIEW_PVT
- show dependent code
BSC_TAB_IND_V
BSC_UPDATE
- show dependent code
BSC_UPDATE_INC
- show dependent code
BSC_UPDATE_LOCK
- show dependent code
BSC_UPDATE_UTIL
- show dependent code
BSC_UTILITY
- show dependent code
|
|
|
|