APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 43: (SELECT level_view_name FROM bsc_sys_dim_levels_b WHERE dim_level_id =b.dim_level_id)level_view_name

39: SELECT DISTINCT a.tab_id,
40: a.dim_level_index,
41: a.dim_level_value,
42: b.dim_level_id,
43: (SELECT level_view_name FROM bsc_sys_dim_levels_b WHERE dim_level_id =b.dim_level_id)level_view_name
44: FROM bsc_user_list_access a,
45: bsc_sys_com_dim_levels b
46: WHERE a.tab_id =b.tab_id
47: AND a.dim_level_index= b.dim_level_index

Line 581: FROM bsc_sys_dim_levels_b

577: AND dim_level_id = p_dim_level_id;
578:
579: CURSOR c_dim_table IS
580: SELECT level_table_name
581: FROM bsc_sys_dim_levels_b
582: WHERE dim_level_id = p_dim_level_id;
583:
584: CURSOR c_dim_view IS
585: SELECT level_view_name

Line 586: FROM bsc_sys_dim_levels_b

582: WHERE dim_level_id = p_dim_level_id;
583:
584: CURSOR c_dim_view IS
585: SELECT level_view_name
586: FROM bsc_sys_dim_levels_b
587: WHERE dim_level_id = p_dim_level_id;
588:
589: BEGIN
590:

Line 837: FROM bsc_sys_dim_levels_b

833: WHERE a.dim_level_id = p_dim_level_id AND a.relation_type=1 ;
834:
835: CURSOR c_dim_view IS
836: SELECT level_view_name
837: FROM bsc_sys_dim_levels_b
838: WHERE dim_level_id = p_dim_level_id;
839:
840: l_rel_col VARCHAR2(100);
841: l_sql_tables VARCHAR2(1000);

Line 1391: FROM bsc_sys_dim_levels_b d

1387: WHERE a.indicator IN (SELECT b.indicator
1388: FROM bsc_tab_indicators b
1389: WHERE b.tab_id = p_tab_id)
1390: AND a.level_shortname IN ( SELECT d.short_name
1391: FROM bsc_sys_dim_levels_b d
1392: WHERE d.dim_level_id = p_dim_level_id);
1393:
1394: CURSOR c_parents IS
1395: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col