DBA Data[Home] [Help]

APPS.BSC_OAF_VIEWS_PVT dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 342: BSC_KPI_ANALYSIS_MEASURES_B MS

338: --Get Defaults
339: SELECT DISTINCT DF.A0_DEFAULT,DF.A1_DEFAULT,DF.A2_DEFAULT,MS.SERIES_ID
340: INTO d_A0,d_A1,d_A2,d_SERIES_ID
341: FROM BSC_DB_COLOR_AO_DEFAULTS_V DF,
342: BSC_KPI_ANALYSIS_MEASURES_B MS
343: WHERE
344: DEFAULT_VALUE =1 AND
345: DF.INDICATOR = MS.INDICATOR AND
346: DF.A0_DEFAULT = MS.ANALYSIS_OPTION0 AND

Line 360: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,

356: --Get if the measure is BSC or PMF
357: --Bug #2660714
358: SELECT NVL(DS.SOURCE,'BSC') VAL
359: INTO h_measure_source
360: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,
361: BSC_SYS_DATASETS_B DS
362: WHERE
363: ANALYSIS_OPTION0 =X_A0 AND
364: ANALYSIS_OPTION1 =X_A1 AND

Line 720: BSC_KPI_ANALYSIS_MEASURES_B MS

716: --Get Defaults
717: SELECT DISTINCT DF.A0_DEFAULT,DF.A1_DEFAULT,DF.A2_DEFAULT,MS.SERIES_ID
718: INTO d_A0,d_A1,d_A2,d_SERIES_ID
719: FROM BSC_DB_COLOR_AO_DEFAULTS_V DF,
720: BSC_KPI_ANALYSIS_MEASURES_B MS
721: WHERE
722: DEFAULT_VALUE =1 AND
723: DF.INDICATOR = MS.INDICATOR AND
724: DF.A0_DEFAULT = MS.ANALYSIS_OPTION0 AND