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

VIEW: APPS.BSC_KPI_ANALYSIS_MEASURES_VL

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

View Type

MultiLingual view (a language resolved view of the data.)


BSC_KPI_ANALYSIS_MEASURES_VL is a view that joins the translated, language specific values from BSC_KPI_ANALYSIS_MEASURES_TL with the non-displayed data from BSC_KPI_ANALYSIS_MEASURES_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
ANALYSIS_OPTION0 NUMBER (3) Yes
ANALYSIS_OPTION1 NUMBER (3) Yes
ANALYSIS_OPTION2 NUMBER (3) Yes
SERIES_ID NUMBER (3) Yes
NAME VARCHAR2 (255) Yes
HELP VARCHAR2 (1024) Yes
DATASET_ID NUMBER (5) Yes
AXIS NUMBER (3) Yes
SERIES_TYPE NUMBER (3) Yes
STACK_SERIES_ID NUMBER (3)
BM_FLAG NUMBER (3) Yes
BUDGET_FLAG NUMBER (3) Yes
DEFAULT_VALUE NUMBER (3) Yes
SERIES_COLOR NUMBER (11) Yes
BM_COLOR NUMBER (11) Yes
PROTOTYPE_FLAG NUMBER (3)
Base series identifier to stack
KPI_MEASURE_ID NUMBER

Unique key for the KPI Measure. Stands for the combination of AO1, AO2, AO3 and Data Series
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INDICATOR
,      ANALYSIS_OPTION0
,      ANALYSIS_OPTION1
,      ANALYSIS_OPTION2
,      SERIES_ID
,      NAME
,      HELP
,      DATASET_ID
,      AXIS
,      SERIES_TYPE
,      STACK_SERIES_ID
,      BM_FLAG
,      BUDGET_FLAG
,      DEFAULT_VALUE
,      SERIES_COLOR
,      BM_COLOR
,      PROTOTYPE_FLAG
,      KPI_MEASURE_ID
FROM APPS.BSC_KPI_ANALYSIS_MEASURES_VL;

Dependencies

[top of page]

APPS.BSC_KPI_ANALYSIS_MEASURES_VL references the following:

SchemaAPPS
SynonymBSC_KPI_ANALYSIS_MEASURES_B
SynonymBSC_KPI_ANALYSIS_MEASURES_TL
APPS.BSC_KPI_ANALYSIS_MEASURES_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_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_DATASETS_PVT - show dependent code
ViewBSC_DB_DATASET_DIM_SETS_V
Package BodyBSC_KPI_COLOR_PROPERTIES_PUB - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_OAF_VIEWS_PVT - show dependent code