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_COPY_INDICATOR_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 1825: bsc_kpi_dim_levels_b kl,

1821: kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,
1822: parent_level_index,parent_level_rel,table_relation,
1823: parent_level_index2,parent_level_rel2
1824: FROM
1825: bsc_kpi_dim_levels_b kl,
1826: bsc_sys_dim_levels_b dl
1827: WHERE
1828: kl.indicator = p_Target_Indicator AND
1829: kl.level_table_name = dl.level_Table_name

Line 1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');

1839:
1840: l_sql := 'SELECT kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,';
1841: l_sql := l_sql || 'parent_level_index,parent_level_rel,table_relation,';
1842: l_sql := l_sql || 'parent_level_index2,parent_level_rel2 ';
1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');
1845: l_sql := l_sql || ' dl WHERE kl.indicator = :1 AND dl.dim_level_id = :2 AND kl.dim_set_id = :3 AND ';
1846: l_sql := l_sql || ' kl.level_table_name = dl.level_Table_name ORDER BY dim_set_id,dim_level_index ';
1847:

Line 1886: bsc_kpi_dim_levels_b

1882: WHERE
1883: indicator = p_Target_Indicator;
1884:
1885: UPDATE
1886: bsc_kpi_dim_levels_b
1887: SET
1888: default_key_value = NULL
1889: ,target_level=1
1890: WHERE

Line 1908: l_sql := 'UPDATE bsc_kpi_dim_levels_b tar SET tar.default_key_value = (SELECT src.default_key_value ';

1904: END IF;*/
1905:
1906: BSC_DESIGNER_PVT.ActionFlag_Change( p_Target_Indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
1907: ELSE
1908: l_sql := 'UPDATE bsc_kpi_dim_levels_b tar SET tar.default_key_value = (SELECT src.default_key_value ';
1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1910: l_sql := l_sql || ' src WHERE src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;

Line 1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');

1905:
1906: BSC_DESIGNER_PVT.ActionFlag_Change( p_Target_Indicator, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
1907: ELSE
1908: l_sql := 'UPDATE bsc_kpi_dim_levels_b tar SET tar.default_key_value = (SELECT src.default_key_value ';
1909: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1910: l_sql := l_sql || ' src WHERE src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;
1913:

Line 1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');

1913:
1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';
1920: l_sql := l_sql || ' src.dim_set_id = dl.dim_set_id AND src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1921: l_sql := l_sql || ' sys.dim_level_id = tar.dim_level_id) WHERE tar.indicator = :2';

Line 2015: bsc_kpi_dim_levels_b

2011: COUNT(1)
2012: INTO
2013: l_count
2014: FROM
2015: bsc_kpi_dim_levels_b
2016: WHERE
2017: indicator = p_Target_Indicator AND
2018: dim_set_id = l_dim_set_id AND
2019: default_key_value IS NULL AND UPPER(default_value)= 'C';

Line 2125: bsc_kpi_dim_levels_b

2121: COUNT(1)
2122: INTO
2123: l_Count
2124: FROM
2125: bsc_kpi_dim_levels_b
2126: WHERE
2127: indicator = p_Target_Indicator;
2128:
2129: IF l_Count > 3 THEN