[Home] [Help]
280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login
284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m
285: WHERE i.short_name = m.short_name (+)
286: and (d.source is null or d.source = 'PMF')
287: and m.measure_id = d.measure_id1 (+)
288: and (i.dataset_id is null or d.dataset_id <> i.dataset_id);
805: ,B.dataset_id
806: ,M.measure_id
807: FROM bsc_sys_measures M
808: ,bsc_sys_datasets_vl V
809: ,bis_indicators_Vl B
810: WHERE M.measure_id = V.measure_id1
811: AND B.dataset_id = V.dataset_id
812: AND V.SOURCE = 'BSC'
813: AND M.short_name IS NULL;
2586: I.NAME
2587: FROM
2588: BSC_SYS_MEASURES M,
2589: BSC_SYS_DATASETS_VL D,
2590: BIS_INDICATORS_VL I
2591: WHERE
2592: M.MEASURE_ID = D.MEASURE_ID1 AND
2593: D.DATASET_ID=I.DATASET_ID AND
2594: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2601: I.DATASET_ID,
2602: I.NAME
2603: FROM
2604: BSC_SYS_MEASURES M,
2605: BIS_INDICATORS_VL I
2606: WHERE
2607: M.SHORT_NAME = I.SHORT_NAME AND
2608: M.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2609: M.MEASURE_COL = I.SHORT_NAME ORDER BY I.DATASET_ID;*/