DBA Data[Home] [Help]

APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 749: FROM BSC_DB_DATASET_DIM_SETS_V a, bsc_kpi_dim_levels_vl b

745: ) IS
746: l_count NUMBER;
747: CURSOR c_dim_obj_objectives IS
748: SELECT a.indicator indicator, a.kpi_measure_id
749: FROM BSC_DB_DATASET_DIM_SETS_V a, bsc_kpi_dim_levels_vl b
750: WHERE a.indicator = b.indicator
751: AND a.dim_set_id = b.dim_set_id
752: AND b.level_shortname = p_dim_obj_short_name;
753:

Line 1574: bsc_kpi_dim_levels_vl b

1570: CURSOR c_kpi_meas_props IS
1571: SELECT a.indicator,
1572: a.kpi_measure_id
1573: FROM bsc_db_dataset_dim_sets_v a,
1574: bsc_kpi_dim_levels_vl b
1575: WHERE a.indicator =b.indicator
1576: AND a.dim_set_id =b.dim_set_id
1577: AND b.level_shortname =p_dim_obj_short_name;
1578:

Line 3833: bsc_kpi_dim_levels_vl b,

3829: SELECT a.indicator indicator,
3830: a.kpi_measure_id,
3831: c.color_by_total
3832: FROM bsc_db_dataset_dim_sets_v a,
3833: bsc_kpi_dim_levels_vl b,
3834: bsc_kpi_measure_props c
3835: WHERE a.indicator =b.indicator
3836: AND a.dim_set_id =b.dim_set_id
3837: AND c.indicator = a.indicator