[Home] [Help]
1327: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1328:
1329: CURSOR indicators_cursor is
1330: SELECT distinct indicator
1331: FROM bsc_kpi_analysis_measures_b
1332: WHERE dataset_id = l_Dataset_Rec.Bsc_Dataset_Id;
1333:
1334: BEGIN
1335: l_Dataset_Rec := p_Dataset_Rec;
2276: ,x_msg_data OUT NOCOPY VARCHAR2
2277: ) IS
2278:
2279: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
2280: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
2281:
2282: CURSOR c_kpis IS
2283: SELECT
2284: km.indicator,
2286: km.analysis_option1,
2287: km.analysis_option2,
2288: km.series_id
2289: FROM
2290: bsc_kpi_analysis_measures_b km,
2291: bsc_kpi_measure_props kp
2292: WHERE
2293: kp.indicator = km.indicator AND
2294: kp.kpi_measure_id = km.kpi_measure_id AND
3881: from bsc_kpis_vl k
3882: where indicator in
3883: (
3884: select distinct indicator
3885: from bsc_kpi_analysis_measures_b d
3886: where dataset_id = p_dataset_id
3887: )
3888: and k.share_flag <> 2;
3889: begin
3925: FROM bsc_kpis_vl k
3926: WHERE indicator IN
3927: (
3928: SELECT DISTINCT d.indicator
3929: FROM bsc_kpi_analysis_measures_b d,
3930: bsc_kpis_b kpi
3931: WHERE d.dataset_id = p_dataset_id
3932: AND d.indicator = kpi.indicator
3933: AND kpi.short_name IS NOT NULL
3989: l_dataset_list varchar2(5000);
3990:
3991: cursor c_Indicators_Cursor is
3992: SELECT DISTINCT B.NAME||'['||B.INDICATOR||']' NAME
3993: FROM BSC_KPI_ANALYSIS_MEASURES_B A,
3994: BSC_KPIS_VL B,
3995: BSC_DB_COLOR_KPI_DEFAULTS_V D
3996: WHERE INSTR(L_DATASET_LIST, ','||A.DATASET_ID||',') > 0
3997: AND D.DATASET_ID = A.DATASET_ID
4539: SELECT
4540: OB.NAME
4541: FROM
4542: BSC_KPIS_VL OB,
4543: BSC_KPI_ANALYSIS_MEASURES_B AM,
4544: BSC_SYS_DATASETS_B ME
4545: WHERE
4546: ME.DATASET_ID = p_Dataset_Id AND
4547: AM.DATASET_ID = ME.DATASET_ID AND