eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 977: FROM BSC_KPI_ANALYSIS_MEASURES_B

973: END IF;
974:
975: SELECT NVL(MAX(ANALYSIS_OPTION0), 0)
976: INTO l_Last_Analysis_Option
977: FROM BSC_KPI_ANALYSIS_MEASURES_B
978: WHERE INDICATOR = l_kpi_Id;
979:
980: IF(l_Analysis_Option_Id <= l_Last_Analysis_Option) THEN
981: BSC_BIS_KPI_CRUD_PUB.Referesh_AK_Metadata (

Line 2577: FROM BSC_KPI_ANALYSIS_MEASURES_B A

2573: SELECT A.ANALYSIS_OPTION0
2574: , A.ANALYSIS_OPTION1
2575: , A.ANALYSIS_OPTION2
2576: , A.SERIES_ID
2577: FROM BSC_KPI_ANALYSIS_MEASURES_B A
2578: WHERE A.INDICATOR = p_Kpi_Id
2579: AND A.DATASET_ID = p_Dataset_Id;
2580:
2581:

Line 2651: FROM BSC_KPI_ANALYSIS_MEASURES_B K

2647:
2648:
2649: SELECT COUNT(1)
2650: INTO l_count
2651: FROM BSC_KPI_ANALYSIS_MEASURES_B K
2652: WHERE K.INDICATOR = p_Kpi_Id;
2653:
2654: RETURN l_count;
2655: END Get_Num_Measures_By_Kpi;

Line 2772: FROM BSC_KPI_ANALYSIS_MEASURES_B A

2768: l_counter NUMBER;
2769:
2770: CURSOR c_AO IS
2771: SELECT A.ANALYSIS_OPTION0
2772: FROM BSC_KPI_ANALYSIS_MEASURES_B A
2773: WHERE A.INDICATOR = p_Kpi_Id
2774: AND A.DATASET_ID = p_Dataset_Id;
2775:
2776:

Line 2920: FROM BSC_KPI_ANALYSIS_MEASURES_B

2916: l_AO_Id NUMBER;
2917:
2918: CURSOR c_AO IS
2919: SELECT ANALYSIS_OPTION0
2920: FROM BSC_KPI_ANALYSIS_MEASURES_B
2921: WHERE DATASET_ID = p_Dataset_Id
2922: AND INDICATOR = p_Kpi_Id;
2923: BEGIN
2924:

Line 5415: FROM BSC_KPI_ANALYSIS_MEASURES_B B

5411:
5412: -- if the measure added is of type Exisitng, then add the
5413: -- same to the list of data series.
5414: SELECT COUNT(1) INTO l_Count1
5415: FROM BSC_KPI_ANALYSIS_MEASURES_B B
5416: WHERE B.DATASET_ID = l_Dataset_Id
5417: AND B.INDICATOR = l_Kpi_id;
5418:
5419: IF((l_Returned_Kpi_Id =BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_Measure_Source =BSC_BIS_MEASURE_PUB.c_BSC) OR l_Count1 = 0) THEN

Line 6730: , BSC_KPI_ANALYSIS_MEASURES_B AM

6726: CURSOR c_Tab_List IS
6727: SELECT T.NAME
6728: FROM BSC_TABS_VL T
6729: , BSC_TAB_INDICATORS TI
6730: , BSC_KPI_ANALYSIS_MEASURES_B AM
6731: , BIS_INDICATORS BI
6732: WHERE BI.SHORT_NAME = l_Measure_Short_Name
6733: AND AM.DATASET_ID = BI.DATASET_ID
6734: AND TI.INDICATOR = AM.INDICATOR

Line 6745: , BSC_KPI_ANALYSIS_MEASURES_B A

6741:
6742: CURSOR c_Kpi_Report_List IS
6743: SELECT K.NAME || ' [' || K.INDICATOR || ']' NAME
6744: FROM BSC_KPIS_VL K
6745: , BSC_KPI_ANALYSIS_MEASURES_B A
6746: , BIS_INDICATORS B
6747: WHERE K.INDICATOR = A.INDICATOR
6748: AND A.DATASET_ID = B.DATASET_ID
6749: AND B.SHORT_NAME = l_Measure_Short_Name;

Line 7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;

7254: ,x_msg_data OUT NOCOPY VARCHAR2
7255: ) IS
7256:
7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;
7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;
7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;
7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;
7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;
7262:

Line 7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;

7255: ) IS
7256:
7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;
7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;
7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;
7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;
7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;
7262:
7263: CURSOR c_get_ana_options IS

Line 7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;

7256:
7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;
7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;
7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;
7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;
7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;
7262:
7263: CURSOR c_get_ana_options IS
7264: SELECT a.indicator,a.analysis_option0,a.analysis_option1,a.analysis_option2,a.series_id

Line 7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;

7257: l_measure_shortname BIS_INDICATORS.SHORT_NAME%TYPE;
7258: l_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE;
7259: l_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE;
7260: l_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE;
7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;
7262:
7263: CURSOR c_get_ana_options IS
7264: SELECT a.indicator,a.analysis_option0,a.analysis_option1,a.analysis_option2,a.series_id
7265: FROM bsc_oaf_analysys_opt_comb_v a

Line 7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE

7264: SELECT a.indicator,a.analysis_option0,a.analysis_option1,a.analysis_option2,a.series_id
7265: FROM bsc_oaf_analysys_opt_comb_v a
7266: WHERE a.indicator = p_indicator;
7267:
7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b

Line 7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE

7265: FROM bsc_oaf_analysys_opt_comb_v a
7266: WHERE a.indicator = p_indicator;
7267:
7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b
7273: WHERE a.dataset_id = b.dataset_id

Line 7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE

7266: WHERE a.indicator = p_indicator;
7267:
7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b
7273: WHERE a.dataset_id = b.dataset_id
7274: AND B.INDICATOR = p_indicator

Line 7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS

7267:
7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b
7273: WHERE a.dataset_id = b.dataset_id
7274: AND B.INDICATOR = p_indicator
7275: AND B.ANALYSIS_OPTION0 = p_ana_option0

Line 7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b

7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE
7270: ,p_ana_option2 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION2%TYPE
7271: ,p_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE) IS
7272: SELECT a.short_name FROM bis_indicators a,bsc_kpi_analysis_measures_b b
7273: WHERE a.dataset_id = b.dataset_id
7274: AND B.INDICATOR = p_indicator
7275: AND B.ANALYSIS_OPTION0 = p_ana_option0
7276: AND B.ANALYSIS_OPTION1 = p_ana_option1

Line 8257: FROM BSC_KPI_ANALYSIS_MEASURES_B B

8253: ELSE
8254: l_Dataset_Id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(l_Measure_Short_Name);
8255:
8256: SELECT COUNT(1) INTO l_Count
8257: FROM BSC_KPI_ANALYSIS_MEASURES_B B
8258: WHERE B.DATASET_ID = l_Dataset_Id
8259: AND B.INDICATOR = p_Kpi_Id;
8260:
8261: -- the dataset already belongs to the current indicator data series.

Line 8292: FROM BSC_KPI_ANALYSIS_MEASURES_B A

8288: BEGIN
8289:
8290: SELECT A.SERIES_ID
8291: INTO l_Data_Series_Id
8292: FROM BSC_KPI_ANALYSIS_MEASURES_B A
8293: WHERE A.INDICATOR = p_Kpi_Id
8294: AND A.ANALYSIS_OPTION0 = 0
8295: AND A.ANALYSIS_OPTION1 = 0
8296: AND A.ANALYSIS_OPTION2 = 0

Line 9302: FROM BSC_KPI_ANALYSIS_MEASURES_B K

9298: , p_Kpi_id IN NUMBER
9299: ) RETURN VARCHAR2 IS
9300: CURSOR c_Meas_Short_Names IS
9301: SELECT I.SHORT_NAME
9302: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9303: , BIS_INDICATORS I
9304: WHERE K.INDICATOR = p_Kpi_Id
9305: AND K.ANALYSIS_OPTION0 = 0
9306: AND K.ANALYSIS_OPTION1 = 0

Line 9343: FROM BSC_KPI_ANALYSIS_MEASURES_B K

9339: ) RETURN VARCHAR2 IS
9340:
9341: CURSOR c_Meas_Short_Names IS
9342: SELECT I.SHORT_NAME
9343: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9344: , BIS_INDICATORS I
9345: WHERE K.INDICATOR = p_Kpi_Id
9346: AND K.ANALYSIS_OPTION0 = 0
9347: AND K.ANALYSIS_OPTION1 = 0

Line 9365: FROM BSC_KPI_ANALYSIS_MEASURES_B K

9361: l_CurrentMeasCnt := LENGTH(l_Measure_Short_Names) - LENGTH(REPLACE(l_Measure_Short_Names,',')) + 1 ;
9362: END IF;
9363:
9364: SELECT COUNT(1) INTO l_PreviousMeasCnt
9365: FROM BSC_KPI_ANALYSIS_MEASURES_B K
9366: , BIS_INDICATORS I
9367: WHERE K.INDICATOR = p_Kpi_Id
9368: AND K.ANALYSIS_OPTION0 = 0
9369: AND K.ANALYSIS_OPTION1 = 0