DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_DB_COLOR_AO_DEFAULTS_V

Line 908: FROM BSC_DB_COLOR_AO_DEFAULTS_V

904: WHERE INDICATOR = l_indicator AND NODE_ID = s_node;
905:
906: CURSOR c_color_AO_DEFAULT IS
907: SELECT A0_DEFAULT,A1_DEFAULT,A2_DEFAULT
908: FROM BSC_DB_COLOR_AO_DEFAULTS_V
909: WHERE INDICATOR = l_indicator;
910:
911: CURSOR c_kpi_analysis IS
912: SELECT LANGUAGE,SOURCE_LANG,NAME

Line 1153: FROM BSC_DB_COLOR_AO_DEFAULTS_V

1149: WHERE INDICATOR = l_indicator AND NODE_ID = s_node
1150: AND F.FORMAT_ID = B.FORMAT_ID;
1151: CURSOR c_color_AO_DEFAULT IS
1152: SELECT A0_DEFAULT,A1_DEFAULT,A2_DEFAULT
1153: FROM BSC_DB_COLOR_AO_DEFAULTS_V
1154: WHERE INDICATOR = l_indicator;
1155:
1156: CURSOR c_analisys_measure IS
1157: SELECT B.SERIES_ID,F.FORMAT,DS.COLOR_METHOD

Line 1282: BSC_DB_COLOR_AO_DEFAULTS_V DF

1278: INTO h_Kpi_Measure_Source
1279: FROM BSC_SYS_DATASETS_B A,
1280: (SELECT DATASET_ID
1281: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,
1282: BSC_DB_COLOR_AO_DEFAULTS_V DF
1283: WHERE ANALYSIS_OPTION0 = DF.A0_DEFAULT
1284: AND ANALYSIS_OPTION1 = DF.A1_DEFAULT
1285: AND ANALYSIS_OPTION2= DF.A2_DEFAULT
1286: AND DEFAULT_VALUE = 1