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


VIEW: APPS.BSC_KPIS_VL

Object Details
Object Name: BSC_KPIS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBSC.BSC_KPIS_VL
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.BSC_KPIS_VL references the following:

SchemaAPPS
SynonymBSC_KPIS_B
SynonymBSC_KPIS_TL
SynonymBSC_SYS_CALENDARS_B
APPS.BSC_KPIS_VL is referenced by following:

SchemaAPPS
Package BodyBSC_ANALYSIS_OPTION_PUB - show dependent code
Package BodyBSC_ANALYSIS_OPTION_PVT - show dependent code
Package BodyBSC_BIS_DIMENSION_PUB - show dependent code
Package BodyBSC_BIS_DIM_OBJ_PUB - show dependent code
Package BodyBSC_BIS_DIM_REL_PUB - show dependent code
Package BodyBSC_BIS_KPI_CRUD_PUB - show dependent code
Package BodyBSC_BIS_KPI_MEAS_PUB - show dependent code
Package BodyBSC_BIS_MEASURE_PUB - show dependent code
Package BodyBSC_BSC_ADAPTER - show dependent code
Package BodyBSC_CALENDAR_PUB - show dependent code
Package BodyBSC_COPY_INDICATOR_PUB - show dependent code
Package BodyBSC_DATASETS_PVT - show dependent code
Package BodyBSC_DBGEN_BSC_READER - show dependent code
Package BodyBSC_DBGEN_METADATA_READER - show dependent code
Package BodyBSC_DBGEN_UTILS - show dependent code
Package BodyBSC_DEFAULT_KEY_ITEM_PUB - show dependent code
Package BodyBSC_DESIGNER_PVT - show dependent code
Package BodyBSC_KPI_PVT - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_METADATA_OPTIMIZER_PKG - show dependent code
PL/SQL PackageBSC_METADATA_OPTIMIZER_PKG - show dependent code
PL/SQL PackageBSC_MIGREATION_UI - show dependent code
Package BodyBSC_MO_DOC_PKG - show dependent code
Package BodyBSC_MO_HELPER_PKG - show dependent code
Package BodyBSC_MO_INDICATOR_PKG - show dependent code
Package BodyBSC_MO_UI_PKG - show dependent code
Package BodyBSC_OBJECTIVE_METADATA_SETUP - show dependent code
Package BodyBSC_PERIODICITIES_PUB - show dependent code
Package BodyBSC_PMF_UI_WRAPPER - show dependent code
Package BodyBSC_SIMULATION_VIEW_PUB - show dependent code
Package BodyBSC_SIMULATION_VIEW_PVT - show dependent code
ViewBSC_TAB_IND_V
Package BodyBSC_UPDATE - show dependent code
Package BodyBSC_UPDATE_INC - show dependent code
Package BodyBSC_UPDATE_LOCK - show dependent code
Package BodyBSC_UPDATE_UTIL - show dependent code
Package BodyBSC_UTILITY - show dependent code