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_DIM_LEVEL_FILTERS_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 344: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,

340: l_need_view BOOLEAN;
341:
342: CURSOR c_parents IS
343: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
344: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
345: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
346: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
347: FROM bsc_sys_dim_level_rels a
348: WHERE a.dim_level_id = p_dim_level_id

Line 565: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,

561: l_cnt NUMBER;
562:
563: CURSOR c_parents IS
564: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
565: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
566: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
567: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
568: FROM bsc_sys_dim_level_rels a
569: WHERE a.dim_level_id = p_dim_level_id

Line 829: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,

825: IS
826:
827: CURSOR c_parents IS
828: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col,
829: (SELECT b.name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.parent_dim_level_id) parent_name,
830: (SELECT c.level_view_name FROM bsc_sys_filters_views c WHERE a.parent_dim_level_id = c.dim_level_id AND c.source_type= 1
831: AND rownum <2 AND c.source_code=p_tab_id) parent_filter_view
832: FROM bsc_sys_dim_level_rels a
833: WHERE a.dim_level_id = p_dim_level_id AND a.relation_type=1 ;

Line 1567: SELECT * FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;

1563: l_ch_level_view VARCHAR2(100);
1564: l_pa_level_view VARCHAR2(100);
1565:
1566: CURSOR c_dim_details(cp_dim_level_id NUMBER) IS
1567: SELECT * FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;
1568:
1569: CURSOR c_kpi_dim_level_details(cp_level_shortname VARCHAR2) IS
1570: SELECT *
1571: FROM bsc_kpi_dim_levels_vl

Line 1780: SELECT short_name FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;

1776: l_ch_level_view VARCHAR2(100);
1777: l_pa_level_view VARCHAR2(100);
1778:
1779: CURSOR c_dim_details(cp_dim_level_id NUMBER) IS
1780: SELECT short_name FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;
1781:
1782: CURSOR c_kpi_dim_level_details(cp_level_shortname VARCHAR2) IS
1783: SELECT *
1784: FROM bsc_kpi_dim_levels_vl

Line 1791: (SELECT b.short_name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.dim_level_id and rownum < 2) child_short_name

1787: );
1788:
1789: CURSOR c_childs IS
1790: SELECT a.dim_level_id child_dim_level_id,
1791: (SELECT b.short_name FROM bsc_sys_dim_levels_vl b WHERE b.dim_level_id = a.dim_level_id and rownum < 2) child_short_name
1792: FROM bsc_sys_dim_level_rels a
1793: WHERE a.parent_dim_level_id = p_dim_level_id
1794: AND a.relation_type=1
1795: AND a.dim_level_id IN