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_BSC_ADAPTER dependencies on BSC_SYS_FILTERS

Line 2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2527: end if;
2528: end loop;
2529: --if there is filter, make an entry also for the filter table
2530: if l_number_filter>0 then
2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2532: 'LEVEL TABLE')=false then
2533: return false;
2534: end if;
2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2531: if BSC_IM_INT_MD.create_fk('SOURCE_TYPE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2532: 'LEVEL TABLE')=false then
2533: return false;
2534: end if;
2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2536: 'LEVEL TABLE')=false then
2537: return false;
2538: end if;
2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2535: if BSC_IM_INT_MD.create_fk('SOURCE_CODE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2536: 'LEVEL TABLE')=false then
2537: return false;
2538: end if;
2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2540: 'LEVEL TABLE')=false then
2541: return false;
2542: end if;
2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

Line 2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',

2539: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_ID','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2540: 'LEVEL TABLE')=false then
2541: return false;
2542: end if;
2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2544: 'LEVEL TABLE')=false then
2545: return false;
2546: end if;
2547: if BSC_IM_UTILS.in_array(l_dim_level_tables,l_number_dim_level_tables,'BSC_SYS_FILTERS')=false then

Line 2547: if BSC_IM_UTILS.in_array(l_dim_level_tables,l_number_dim_level_tables,'BSC_SYS_FILTERS')=false then

2543: if BSC_IM_INT_MD.create_fk('DIM_LEVEL_VALUE','LEVEL TABLE','BSC_SYS_FILTERS',null,null,null,'BSC',
2544: 'LEVEL TABLE')=false then
2545: return false;
2546: end if;
2547: if BSC_IM_UTILS.in_array(l_dim_level_tables,l_number_dim_level_tables,'BSC_SYS_FILTERS')=false then
2548: l_number_dim_level_tables:=l_number_dim_level_tables+1;
2549: l_dim_level_tables(l_number_dim_level_tables):='BSC_SYS_FILTERS';
2550: end if;
2551: end if;

Line 2549: l_dim_level_tables(l_number_dim_level_tables):='BSC_SYS_FILTERS';

2545: return false;
2546: end if;
2547: if BSC_IM_UTILS.in_array(l_dim_level_tables,l_number_dim_level_tables,'BSC_SYS_FILTERS')=false then
2548: l_number_dim_level_tables:=l_number_dim_level_tables+1;
2549: l_dim_level_tables(l_number_dim_level_tables):='BSC_SYS_FILTERS';
2550: end if;
2551: end if;
2552: end;
2553: ----------------------------------------------------

Line 3062: ','||bsc_im_utils.get_table_owner('BSC_SYS_FILTERS')||'.bsc_sys_filters f'||p_count||',';

3058: if l_res=1 then
3059: --there is a filter at this level. use it
3060: p_count:=p_count+1;
3061: p_from_stmt:=p_from_stmt||bsc_im_utils.get_table_owner(p_child_level)||'.'||p_child_level||' L'||p_level_count||
3062: ','||bsc_im_utils.get_table_owner('BSC_SYS_FILTERS')||'.bsc_sys_filters f'||p_count||',';
3063: p_where_stmt:=p_where_stmt||' and f'||p_count||'.source_code='||l_source_code||
3064: ' and f'||p_count||'.source_type='||l_source_type||
3065: ' and f'||p_count||'.dim_level_id='||l_dim_level_id||
3066: ' and f'||p_count||'.dim_level_value=L'||p_level_count||'.code ';

Line 3114: select source_type,source_code,dim_level_id from bsc_sys_filters_views where

3110: p_dim_level_id out nocopy number
3111: ) return number is
3112: ----
3113: cursor c3(p_ind number, p_table_name varchar2) is
3114: select source_type,source_code,dim_level_id from bsc_sys_filters_views where
3115: level_table_name=p_table_name
3116: and source_code in (select tab_id from bsc_tab_indicators where indicator=p_ind);
3117: ----
3118: cursor c4(p_type number,p_code number,p_id number) is

Line 3119: select 1 from bsc_sys_filters where source_type=p_type and source_code=p_code

3115: level_table_name=p_table_name
3116: and source_code in (select tab_id from bsc_tab_indicators where indicator=p_ind);
3117: ----
3118: cursor c4(p_type number,p_code number,p_id number) is
3119: select 1 from bsc_sys_filters where source_type=p_type and source_code=p_code
3120: and dim_level_id=p_id and rownum=1;
3121: ----
3122: l_res number;
3123: l_stmt varchar2(8000);

Line 3127: l_stmt:='select source_type,source_code,dim_level_id from bsc_sys_filters_views where '||

3123: l_stmt varchar2(8000);
3124: --------------------------------
3125: Begin
3126: if g_debug then
3127: l_stmt:='select source_type,source_code,dim_level_id from bsc_sys_filters_views where '||
3128: 'level_table_name=:1 and source_code in (select tab_id from bsc_tab_indicators where indicator=:2';
3129: write_to_log_file_n(l_stmt||' '||p_level||' '||p_indicator);
3130: end if;
3131: open c3(p_indicator, p_level);

Line 3138: l_stmt:='select 1 from bsc_sys_filters where source_type=:1 and source_code=:2 '||

3134: if g_debug then
3135: write_to_log_file(p_source_type||' '||p_source_code||' '||p_dim_level_id);
3136: end if;
3137: if g_debug then
3138: l_stmt:='select 1 from bsc_sys_filters where source_type=:1 and source_code=:2 '||
3139: 'and dim_level_id=:3 and rownum=1';
3140: write_to_log_file_n(l_stmt||' '||p_source_type||' '||p_source_code||' '||p_dim_level_id);
3141: end if;
3142: l_res:=null;