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

VIEW: APPS.BSC_DB_DATASET_DIM_SETS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes
A0 NUMBER (3) Yes
A1 NUMBER (3) Yes
A2 NUMBER (3) Yes
SERIES_ID NUMBER (3) Yes
DIM_SET_ID NUMBER

DATASET_ID NUMBER (5) Yes
DEFAULT_VALUE NUMBER (3) Yes
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
,      A0
,      A1
,      A2
,      SERIES_ID
,      DIM_SET_ID
,      DATASET_ID
,      DEFAULT_VALUE
,      KPI_MEASURE_ID
FROM APPS.BSC_DB_DATASET_DIM_SETS_V;

Dependencies

[top of page]

APPS.BSC_DB_DATASET_DIM_SETS_V references the following:

SchemaAPPS
ViewBSC_DB_BASIC_DIM_SETS_V
ViewBSC_KPI_ANALYSIS_MEASURES_VL
APPS.BSC_DB_DATASET_DIM_SETS_V is referenced by following:

SchemaAPPS
Package BodyBSC_BIS_DIMENSION_PUB - show dependent code
Package BodyBSC_BIS_KPI_MEAS_PUB - show dependent code
Package BodyBSC_BIS_WRAPPER_PVT - show dependent code
Package BodyBSC_COLOR_CALC_UTIL - show dependent code
Package BodyBSC_DBGEN_BSC_READER - show dependent code
ViewBSC_DB_COLOR_KPI_DEFAULTS_V
ViewBSC_DB_MEASURE_BY_DIM_SET_V
Package BodyBSC_KPI_SERIES_PUB - show dependent code
Package BodyBSC_LOCKS_PVT - show dependent code
Package BodyBSC_METADATA_DESC - show dependent code
Package BodyBSC_MO_INDICATOR_PKG - show dependent code
Package BodyBSC_OBJ_ANALYSIS_OPTIONS_PUB - show dependent code
Package BodyBSC_UPDATE_UTIL - show dependent code