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_FILTERS_VIEWS

Line 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

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
349: AND a.relation_type=1

Line 367: FROM bsc_sys_filters_views

363: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
364:
365: CURSOR c_fil_view IS
366: SELECT level_view_name
367: FROM bsc_sys_filters_views
368: WHERE source_type = 1
369: AND source_code = p_tab_id
370: AND dim_level_id = p_dim_level_id;
371:

Line 422: --DELETE entry from bsc_sys_filters_views

418: IF (l_view IS NOT NULL) THEN
419:
420: EXECUTE IMMEDIATE ('DROP VIEW ' || l_view); --DROP FILTER VIEW
421:
422: --DELETE entry from bsc_sys_filters_views
423: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view (
424: p_tab_id => p_tab_id
425: ,p_dim_level_id => p_dim_level_id
426: ,p_commit => FND_API.G_FALSE

Line 431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;

427: ,x_return_status => x_return_status
428: ,x_msg_count => x_msg_count
429: ,x_msg_data => x_msg_data
430: );
431: --DELETE FROM bsc_sys_filters_views WHERE source_type=1 AND source_code = p_tab_id AND dim_level_id = p_dim_level_id;
432:
433: --DELTER entry from bsc_sys_filters
434: BSC_DIM_LEVEL_FILTERS_PVT.delete_filters (
435: p_tab_id => p_tab_id

Line 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

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
570: AND a.relation_type=1;

Line 574: FROM bsc_sys_filters_views

570: AND a.relation_type=1;
571:
572: CURSOR c_fil_view IS
573: SELECT level_view_name
574: FROM bsc_sys_filters_views
575: WHERE source_type = 1
576: AND source_code = p_tab_id
577: AND dim_level_id = p_dim_level_id;
578:

Line 624: ---INSERT INTO bsc_sys_filters_views(source_type, source_code, dim_level_id, level_table_name, level_view_name) VALUES (1, p_tab_id, p_dim_level_id, l_table,l_view);

620: ,x_return_status => x_return_status
621: ,x_msg_count => x_msg_count
622: ,x_msg_data => x_msg_data
623: );
624: ---INSERT INTO bsc_sys_filters_views(source_type, source_code, dim_level_id, level_table_name, level_view_name) VALUES (1, p_tab_id, p_dim_level_id, l_table,l_view);
625: END IF;
626:
627: FOR cd IN c_dim_view LOOP
628: l_view_name := cd.level_view_name;

Line 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

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 ;
834:

Line 954: FROM bsc_sys_filters_views

950: IS
951:
952: CURSOR c_filter_view IS
953: SELECT level_view_name
954: FROM bsc_sys_filters_views
955: WHERE source_type=1
956: AND source_code = p_tab_id
957: AND dim_level_id = p_dim_level_id;
958:

Line 1090: FROM bsc_sys_filters_views

1086: ref_cur ref_cursor;
1087:
1088: CURSOR c_ch_dim_view IS
1089: SELECT level_view_name
1090: FROM bsc_sys_filters_views
1091: WHERE source_type = 1
1092: AND source_code = p_tab_id
1093: AND dim_level_id = p_ch_level_id;
1094:

Line 1097: FROM bsc_sys_filters_views

1093: AND dim_level_id = p_ch_level_id;
1094:
1095: CURSOR c_pa_dim_view IS
1096: SELECT level_view_name
1097: FROM bsc_sys_filters_views
1098: WHERE source_type = 1
1099: AND source_code = p_tab_id
1100: AND dim_level_id = p_pa_level_id;
1101: