APPS.BSC_BSC_ADAPTER dependencies on ALL_TAB_COLUMNS

Line 3233: from all_tab_columns

3229: l_reverse varchar2(1000);
3230:
3231: CURSOR cDataType(p_owner in varchar2) is
3232: select decode(data_length, null, data_type, data_type||'('||data_length||')') data_type
3233: from all_tab_columns
3234: where owner=p_owner
3235: and table_name=p_dim_level
3236: and column_name = p_level_pk;
3237:

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 3634: all_tab_columns

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
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name

Line 3637: and all_tab_columns.table_name(+)=p_table

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;
3641: ----

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 3639: and all_tab_columns.owner(+)=p_owner

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);
3643: l_order BSC_IM_UTILS.number_tabletype;

Line 3640: order by all_tab_columns.column_id;

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);
3643: l_order BSC_IM_UTILS.number_tabletype;
3644: --------------------------------------------------

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 3940: from all_tab_columns cols,

3936:
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