eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DBGEN_BSC_READER dependencies on BSC_KPI_PROPERTIES

Line 2412: BSC_KPI_PROPERTIES PROP

2408: function get_all_facts_in_aw return dbms_sql.varchar2_table is
2409: CURSOR cAWFacts IS
2410: SELECT kpi.indicator
2411: FROM BSC_KPIS_VL KPI,
2412: BSC_KPI_PROPERTIES PROP
2413: WHERE KPI.INDICATOR = PROP.INDICATOR
2414: AND PROP.PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE
2415: AND PROP.PROPERTY_VALUE = '2';
2416: l_facts DBMS_SQL.VARCHAR2_TABLE;

Line 2576: BSC_KPI_PROPERTIES

2572: function get_fact_implementation_type(p_fact in varchar2) return varchar2 is
2573: cursor cImplType is
2574: SELECT property_value
2575: FROM
2576: BSC_KPI_PROPERTIES
2577: WHERE INDICATOR = p_fact
2578: AND PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;
2579: l_impl_type varchar2(30);
2580:

Line 2607: bsc_kpi_properties prop,

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
2611: and lvl.level_table_name=p_level_name

Line 2648: bsc_kpi_properties prop,

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
2652: and lvl.level_table_name=p_level_name