APPS.BSC_BSC_ADAPTER dependencies on BSC_DB_TABLES_COLS

Line 95: cursor c1 is select column_name from bsc_db_tables_cols where table_name = p_table_name;

91: p_table_name varchar2,
92: p_measures BSC_IM_UTILS.varchar_tabletype,
93: p_number_measures number
94: ) return varchar2 is
95: cursor c1 is select column_name from bsc_db_tables_cols where table_name = p_table_name;
96: l_column_name VARCHAR2(100);
97: l_ordered_columns varchar2(32000);
98: begin
99: if p_number_measures= 0 then

Line 125: cursor c1 is select column_name from bsc_db_tables_cols where table_name=p_b_table_name

121: return l_ordered_columns;
122: end;
123:
124: function get_prj_union_clause(p_b_table_name varchar2, p_add_alias boolean default true) return varchar2 is
125: cursor c1 is select column_name from bsc_db_tables_cols where table_name=p_b_table_name
126: order by column_type desc;
127: l_stmt varchar2(32000);
128: l_prj_table varchar2(100);
129: begin

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 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 3417: from bsc_db_tables_cols where table_name=p_table

3413: l_stmt varchar2(5000);
3414: ---------------------------------------------
3415: cursor c1(p_table varchar2) is
3416: select table_name,upper(column_name),column_type,source_formula,source_column
3417: from bsc_db_tables_cols where table_name=p_table
3418: order by column_name;
3419: ---------------------------------------------
3420: l_table_name varchar2(100);
3421: Begin

Line 3429: 'from bsc_db_tables_cols where table_name=:1';

3425: l_table_name := p_table_name;
3426: end if;
3427: if g_debug then
3428: l_stmt:='select table_name,upper(column_name),column_type,source_formula,upper(source_column) '||
3429: 'from bsc_db_tables_cols where table_name=:1';
3430: write_to_log_file_n(l_stmt||' '||l_table_name);
3431: end if;
3432: if p_number_cols is null then
3433: p_number_cols:=1;

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 3618: bsc_db_tables_cols,

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
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table

Line 3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name

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'
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

Line 3622: and bsc_db_tables_cols.table_name =p_table

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'
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

Line 3623: and bsc_db_tables_cols.column_type='P'

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'
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;

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 3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_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
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table

Line 3633: bsc_db_tables_cols ,

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
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table

Line 3635: where bsc_db_tables_cols.table_name =p_table

3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner

Line 3636: and bsc_db_tables_cols.column_type='P'

3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner
3640: order by all_tab_columns.column_id;

Line 3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name

3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner
3640: order by all_tab_columns.column_id;
3641: ----
3642: l_owner varchar2(200);

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 3669: write_to_log_file_n('is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id...');

3665: --
3666: if p_number_fk=0 then
3667: --either there are no fk or this could be a table without entries in bsc_kpi_data_tables...like B tables
3668: if g_debug then
3669: write_to_log_file_n('is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id...');
3670: end if;
3671: l_owner:=bsc_im_utils.get_table_owner(l_table_name);
3672: p_number_fk:=p_number_fk+1;
3673: open c1(l_table_name,l_owner);

Line 3752: is select distinct column_name from bsc_db_tables_cols where table_name =p_table_name and

3748: ) return boolean is
3749: l_stmt varchar2(5000);
3750: -----------------------------------------
3751: cursor c1 (p_table_name varchar2)
3752: is select distinct column_name from bsc_db_tables_cols where table_name =p_table_name and
3753: column_type='A' order by column_name;
3754: -----------------------------------------
3755: l_table_name varchar2(100);
3756: Begin

Line 3763: l_stmt:='select distinct column_name from bsc_db_tables_cols where table_name =:1 and '||

3759: else
3760: l_table_name := p_table;
3761: end if;
3762: if g_debug then
3763: l_stmt:='select distinct column_name from bsc_db_tables_cols where table_name =:1 and '||
3764: 'column_type=''A''';
3765: write_to_log_file_n(l_stmt||' '||p_table);
3766: end if;
3767: p_number_measures:=1;