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


VIEW: APPS.BSC_KPI_ANALYSIS_OPTIONS_VL

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

View Type

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


BSC_KPI_ANALYSIS_OPTIONS_VL is a view that joins the translated, language specific values from BSC_KPI_ANALYSIS_OPTIONS_TL with the non-displayed data from BSC_KPI_ANALYSIS_OPTIONS_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_GROUP_ID NUMBER (3) Yes
OPTION_ID NUMBER (3) Yes
PARENT_OPTION_ID NUMBER (3) Yes
GRANDPARENT_OPTION_ID NUMBER (3) Yes
NAME VARCHAR2 (255) Yes
HELP VARCHAR2 (1024) Yes
DIM_SET_ID NUMBER (3) Yes
USER_LEVEL0 NUMBER (3)
USER_LEVEL1 NUMBER (3)
USER_LEVEL1_DEFAULT NUMBER (3)
USER_LEVEL2 NUMBER (3)
USER_LEVEL2_DEFAULT NUMBER (3)
SHORT_NAME VARCHAR2 (30)
Short name
Query Text

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


SELECT INDICATOR
,      ANALYSIS_GROUP_ID
,      OPTION_ID
,      PARENT_OPTION_ID
,      GRANDPARENT_OPTION_ID
,      NAME
,      HELP
,      DIM_SET_ID
,      USER_LEVEL0
,      USER_LEVEL1
,      USER_LEVEL1_DEFAULT
,      USER_LEVEL2
,      USER_LEVEL2_DEFAULT
,      SHORT_NAME
FROM APPS.BSC_KPI_ANALYSIS_OPTIONS_VL;

Dependencies

[top of page]

APPS.BSC_KPI_ANALYSIS_OPTIONS_VL references the following:

SchemaAPPS
SynonymBSC_KPI_ANALYSIS_OPTIONS_B
SynonymBSC_KPI_ANALYSIS_OPTIONS_TL
APPS.BSC_KPI_ANALYSIS_OPTIONS_VL is referenced by following:

SchemaAPPS
Package BodyBSC_ANALYSIS_OPTION_PVT - show dependent code
Package BodyBSC_BIS_KPI_MEAS_PUB - show dependent code
Package BodyBSC_BIS_MEASURE_PUB - show dependent code
Package BodyBSC_DESIGNER_PVT - show dependent code
Package BodyBSC_KPI_SERIES_PUB - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_OAF_VIEWS_PVT - show dependent code
Package BodyBSC_OBJ_ANALYSIS_OPTIONS_PUB - show dependent code
ViewBSC_PMF_MEAS_V
Package BodyBSC_PMF_UI_API_PUB - show dependent code