APPS.BSC_SYNC_MVLOGS dependencies on ALL_TAB_COLUMNS

Line 49: from all_tab_columns cols

45: --we have to modify all the I tables used by objectives
46: procedure alter_objective_input_tables(p_level in varchar2, p_owner in varchar2) is
47: cursor cInputTables(p_level_col varchar2, p_datatype varchar2, p_data_length varchar2 ) is
48: select cols.table_name
49: from all_tab_columns cols
50: , bsc_db_tables tbls
51: where cols.owner=p_owner
52: and cols.table_name=tbls.table_name
53: and tbls.table_type=0

Line 65: , all_tab_columns cols

61:
62: cursor cCol is
63: select level_pk_col, cols.data_type, cols.data_length
64: from bsc_sys_dim_levels_b lvl
65: , all_tab_columns cols
66: where lvl.level_table_name=p_level
67: and lvl.level_table_name = cols.table_name
68: and lvl.level_pk_col = cols.column_name
69: and cols.owner = p_owner;

Line 98: , all_tab_columns cols

94:
95: cursor cCols(p_mv_log varchar2) is
96: select cols.column_name, cols.data_type, cols.data_length
97: from bsc_sys_dim_levels_b lvl
98: , all_tab_columns cols
99: where lvl.level_table_name = p_level
100: and lvl.level_table_name = cols.table_name
101: and cols.owner = p_owner
102: and cols.data_type = 'VARCHAR2'

Line 117: from all_tab_columns

113: and rels.relation_type=1)
114: )
115: minus
116: select column_name, data_type, data_length
117: from all_tab_columns
118: where table_name =(select distinct log_table from all_snapshot_logs where log_owner=p_owner and log_table=p_mv_log )
119: and owner=p_owner
120: and data_type='VARCHAR2';
121: l_datatype_with_length varchar2(100);