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_KPI_DIM_LEVELS_B

Line 21: from bsc_kpi_dim_levels_b kpi,

17: SELECT LEVEL_TABLE_NAME,SHORT_NAME, upper(level_pk_col) level_pk_col
18: FROM
19: BSC_SYS_DIM_LEVELS_B WHERE level_table_name in
20: (select level_table_name
21: from bsc_kpi_dim_levels_b kpi,
22: bsc_tmp_opt_ui_kpis gdb
23: where gdb.indicator=kpi.indicator
24: and gdb.prototype_flag <> 2
25: and gdb.process_id = bsc_metadata_optimizer_pkg.g_ProcessId);

Line 2892: SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c

2888: l_number_pk_col number;
2889: l_view_owner varchar2(200);
2890: --------------------------
2891: cursor c1(p_indicator number,p_dim_set_id number,p_status number,p_table_name varchar2,p_column_type varchar2) is
2892: SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c
2893: WHERE d.indicator = p_indicator AND d.dim_set_id = p_dim_set_id AND d.status = p_status AND d.level_view_name <> (
2894: SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col)
2895: AND c.table_name = p_table_name AND c.column_name = d.level_pk_col AND
2896: c.column_type = p_column_type;

Line 2899: select level_table_name,level_pk_col,parent_level_rel from bsc_kpi_dim_levels_b

2895: AND c.table_name = p_table_name AND c.column_name = d.level_pk_col AND
2896: c.column_type = p_column_type;
2897:
2898: cursor c2(p_indicator number,p_set_id number) is
2899: select level_table_name,level_pk_col,parent_level_rel from bsc_kpi_dim_levels_b
2900: where indicator=p_indicator and dim_set_id=p_set_id;
2901: --------------------------
2902: Begin
2903: if g_debug then

Line 2923: l_stmt:='SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c '||

2919: write_to_log_file('Result '||l_indicator_id||' '||l_dim_set_id);
2920: end if;
2921: if l_indicator_id is not null and l_dim_set_id is not null then
2922: if g_debug then
2923: l_stmt:='SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c '||
2924: 'WHERE d.indicator = :1 AND d.dim_set_id = :2 AND d.status = :3 AND d.level_view_name <> ( '||
2925: 'SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col) '||
2926: 'AND c.table_name = :4 AND c.column_name = d.level_pk_col AND '||
2927: 'c.column_type = :5';

Line 2963: ' from bsc_kpi_dim_levels_b where indicator=:1 and dim_set_id=:2';

2959: ---------------------
2960: begin
2961: if g_debug then
2962: l_stmt:='select level_table_name,level_pk_col,parent_level_rel'||
2963: ' from bsc_kpi_dim_levels_b where indicator=:1 and dim_set_id=:2';
2964: write_to_log_file_n(l_stmt||' '||l_indicator_id||' '||l_dim_set_id);
2965: end if;
2966: ll_number_level:=1;
2967: open c2(l_indicator_id,l_dim_set_id);

Line 3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from

3612: l_stmt varchar2(5000);
3613: --------------------------------------------------
3614: --for S tables
3615: cursor c0 (p_table varchar2)
3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from
3617: bsc_kpi_data_tables,
3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where

Line 3619: bsc_kpi_dim_levels_b

3615: cursor c0 (p_table varchar2)
3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from
3617: bsc_kpi_data_tables,
3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'

Line 3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator

3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --

Line 3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col

3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --
3629: --for the B tables

Line 3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id

3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --
3629: --for the B tables
3630: cursor c1 (p_table varchar2,p_owner varchar2)

Line 3627: order by bsc_kpi_dim_levels_b.dim_level_index;

3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --
3629: --for the B tables
3630: cursor c1 (p_table varchar2,p_owner varchar2)
3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id

Line 3649: write_to_log_file_n('distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index fr...');

3645: l_table_name varchar2(100);
3646: Begin
3647: p_number_fk:=1;
3648: if g_debug then
3649: write_to_log_file_n('distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index fr...');
3650: end if;
3651: if (p_table like 'BSC_B_%PRJ%') then
3652: l_table_name := get_b_table_name_for_prj(p_table);
3653: else

Line 3941: bsc_kpi_dim_levels_b dim

3937: -- bug 3866554, dont assume that the datatype in the above sql is always VARCHAR2
3938: cursor c3 (p_column varchar2)
3939: is select cols.data_type
3940: from all_tab_columns cols,
3941: bsc_kpi_dim_levels_b dim
3942: where cols.table_name = dim.level_table_name
3943: and cols.column_name = 'CODE'
3944: and dim.indicator = p_indicator
3945: and dim.level_pk_col = p_column

Line 3980: bsc_kpi_dim_levels_b dim where dim.indicator = :1

3976: p_number_parameters:=p_number_parameters+1;
3977: end if;
3978: --
3979: l_stmt:=' select cols.data_type from '||bsc_olap_main.g_col_type_table_name||' cols,
3980: bsc_kpi_dim_levels_b dim where dim.indicator = :1
3981: and dim.level_pk_col = :2 and cols.level_table_name = dim.level_table_name';
3982:
3983: l_number_parameters:=1;
3984: if p_type is not null then