DBA Data[Home] [Help]

APPS.BSC_UPDATE_DIM dependencies on BSC_KPI_PROPERTIES

Line 1561: from bsc_kpi_properties p, bsc_kpis_b k

1557: into h_count
1558: from bsc_kpi_dim_levels_b
1559: where indicator in (
1560: select p.indicator
1561: from bsc_kpi_properties p, bsc_kpis_b k
1562: where p.indicator = k.indicator and
1563: p.property_code = h_aw_impl_type_name and
1564: p.property_value = h_aw_impl_type and
1565: k.prototype_flag in (0,6,7)

Line 1597: from bsc_kpi_properties p, bsc_kpis_b k

1593: into h_count
1594: from bsc_kpi_dim_levels_b
1595: where indicator in (
1596: select k.indicator
1597: from bsc_kpi_properties p, bsc_kpis_b k
1598: where p.indicator (+) = k.indicator and
1599: p.property_code (+) = h_mv_impl_type_name and
1600: (p.property_value is null or p.property_value = h_mv_impl_type) and
1601: k.prototype_flag in (0,6,7)