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


VIEW: APPS.BSC_SYS_DATASETS_VL

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

View Type

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


BSC_SYS_DATASETS_VL is a view that joins the translated, language specific values from BSC_SYS_DATASETS_TL with the non-displayed data from BSC_SYS_DATASETS_B . BSC uses this view to display translated information in languages installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DATASET_ID NUMBER (5) Yes
NAME VARCHAR2 (255) Yes
HELP VARCHAR2 (1024) Yes
MEASURE_ID1 NUMBER (5) Yes
OPERATION VARCHAR2 (3)
MEASURE_ID2 NUMBER (5)
FORMAT_ID NUMBER (3) Yes
COLOR_METHOD NUMBER (3) Yes
PROJECTION_FLAG NUMBER (3)
EDW_FLAG NUMBER

AUTOSCALE_FLAG NUMBER

Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT DATASET_ID
,      NAME
,      HELP
,      MEASURE_ID1
,      OPERATION
,      MEASURE_ID2
,      FORMAT_ID
,      COLOR_METHOD
,      PROJECTION_FLAG
,      EDW_FLAG
,      AUTOSCALE_FLAG
,      Y_AXIS_TITLE
,      SOURCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.BSC_SYS_DATASETS_VL;

Dependencies

[top of page]

APPS.BSC_SYS_DATASETS_VL references the following:

SchemaAPPS
SynonymBSC_SYS_DATASETS_B
SynonymBSC_SYS_DATASETS_TL
APPS.BSC_SYS_DATASETS_VL is referenced by following:

SchemaAPPS
ViewBIS_APP_NAMES_RPTS_V
ViewBIS_DISPLAY_MEASURES_V
Package BodyBSC_ANALYSIS_OPTION_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_COLOR_UPGRADE - show dependent code
Package BodyBSC_DATASETS_PUB - show dependent code
Package BodyBSC_DATASETS_PVT - show dependent code
ViewBSC_DB_MEASURE_BY_DIM_SET_V
Package BodyBSC_KPI_SERIES_PUB - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_MO_UI_PKG - show dependent code
Package BodyBSC_OBJ_ANALYSIS_OPTIONS_PUB - show dependent code
Package BodyBSC_PMF_UI_WRAPPER - show dependent code
Package BodyBSC_SIMULATION_VIEW_PVT - show dependent code
PL/SQL PackageBSC_SIMULATION_VIEW_PVT - show dependent code
Package BodyBSC_UPGRADES - show dependent code
PL/SQL PackageBSC_UTILITY - show dependent code
Package BodyBSC_UTILITY - show dependent code