APPS.BSC_DBGEN_BSC_READER dependencies on BSC_KPI_DIM_LEVELS_B

Line 1739: FROM BSC_KPI_DIM_LEVELS_B dim, BSC_KPIS_VL kpi

1735: BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2 (1, p_levels(i));
1736: END LOOP;
1737: --insert the children
1738: l_stmt := 'SELECT distinct dim.INDICATOR, dim.DIM_SET_ID, kpi.name , ''BSC''
1739: FROM BSC_KPI_DIM_LEVELS_B dim, BSC_KPIS_VL kpi
1740: WHERE dim.indicator = kpi.indicator and ('|| l_stmt||') order by indicator, dim_set_id';
1741: OPEN cv FOR l_stmt;
1742: LOOP
1743: FETCH cv INTO l_fact.fact_id, l_fact.dimension_set(1), l_fact.fact_name, l_fact.application_short_name;

Line 2067: bsc_kpi_dim_levels_b a

2063: from
2064: bsc_sys_dim_levels_b a,
2065: (select a.LEVEL_TABLE_NAME,0 RELATION_TYPE
2066: from
2067: bsc_kpi_dim_levels_b a
2068: where
2069: a.indicator=p_kpi
2070: and a.PARENT_LEVEL_INDEX is null
2071: union all

Line 2074: bsc_kpi_dim_levels_b a,

2070: and a.PARENT_LEVEL_INDEX is null
2071: union all
2072: select a.LEVEL_TABLE_NAME,e.RELATION_TYPE
2073: from
2074: bsc_kpi_dim_levels_b a,
2075: bsc_kpi_dim_levels_b b,
2076: bsc_sys_dim_levels_b c,
2077: bsc_sys_dim_levels_b d,
2078: bsc_sys_dim_level_rels e

Line 2075: bsc_kpi_dim_levels_b b,

2071: union all
2072: select a.LEVEL_TABLE_NAME,e.RELATION_TYPE
2073: from
2074: bsc_kpi_dim_levels_b a,
2075: bsc_kpi_dim_levels_b b,
2076: bsc_sys_dim_levels_b c,
2077: bsc_sys_dim_levels_b d,
2078: bsc_sys_dim_level_rels e
2079: where

Line 2155: from bsc_kpi_dim_levels_b kpidim,

2151: p_level varchar2) return varchar2 is
2152: l_stmt VARCHAR2(1000);
2153: CURSOR cFilter IS
2154: select sysdim.dim_level_id, source_type, source_code
2155: from bsc_kpi_dim_levels_b kpidim,
2156: bsc_sys_dim_levels_b sysdim,
2157: bsc_sys_filters_views filters
2158: where
2159: kpidim.level_table_name = sysdim.level_table_name

Line 2188: FROM bsc_kpi_dim_levels_b

2184: p_level varchar2) return varchar2 is
2185: l_stmt VARCHAR2(1000);
2186: CURSOR cFilter IS
2187: SELECT level_view_name
2188: FROM bsc_kpi_dim_levels_b
2189: WHERE indicator=to_number(p_fact)
2190: AND level_table_name = p_level;
2191: l_level_view varchar2(100);
2192: Begin

Line 2606: from bsc_kpi_dim_levels_b lvl,

2602: function is_level_used_by_prod_aw_fact(p_level_name in varchar2) return boolean is
2603: l_count number;
2604: begin
2605: select count(1) into l_count
2606: from bsc_kpi_dim_levels_b lvl,
2607: bsc_kpi_properties prop,
2608: bsc_kpis_vl kpis
2609: where kpis.indicator= lvl.indicator
2610: and kpis.indicator=prop.indicator

Line 2647: from bsc_kpi_dim_levels_b lvl,

2643: insert into bsc_tmp_big_in_cond (session_id, variable_id, value_n) values (l_session_id, 1,
2644: to_number(BSC_DBGEN_METADATA_READER.g_assume_production_facts(i)));
2645:
2646: select count(1) into l_count
2647: from bsc_kpi_dim_levels_b lvl,
2648: bsc_kpi_properties prop,
2649: bsc_kpis_vl kpis
2650: where kpis.indicator= lvl.indicator
2651: and kpis.indicator=prop.indicator