DBA Data[Home] [Help]

APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_SYS_COM_DIM_LEVELS

Line 45: bsc_sys_com_dim_levels b

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
48: AND a.tab_id =p_tab_id
49: AND a.dim_level_value <>0