APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on ALL_TAB_COLUMNS

Line 247: select column_name from sys.all_tab_columns where table_name = l_view_name

243: ) tab3
244: where master_source_type_flag = 'N';
245:
246: cursor c_index_columns is
247: select column_name from sys.all_tab_columns where table_name = l_view_name
248: and column_name not in (
249: select flds.source_column_name
250: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
251: ams_query_template_all qtemp

Line 1160: l_remote_index_string := 'begin select max(COLUMN_ID) into :l_number_of_index from sys.all_tab_columns'||'@'||l_dblink||' where table_name = '''||l_view_name||''' and column_name like ''A%'';end;';

1156: execute immediate l_remote_create_synonym;
1157: Ams_Utility_Pvt.Write_Conc_log('Synonym created. ');
1158:
1159: -- create index for remote table?
1160: l_remote_index_string := 'begin select max(COLUMN_ID) into :l_number_of_index from sys.all_tab_columns'||'@'||l_dblink||' where table_name = '''||l_view_name||''' and column_name like ''A%'';end;';
1161: Ams_Utility_Pvt.Write_Conc_log('l_remote_index_string = '||l_remote_index_string);
1162: BEGIN
1163: execute immediate l_remote_index_string using OUT l_number_of_index;
1164: Ams_Utility_Pvt.Write_Conc_log('number of index = '||l_number_of_index);

Line 1173: l_remote_index_string := 'BEGIN select column_name into :l_index_column from sys.all_tab_columns'||'@'||l_dblink||' where table_name = '''||l_view_name||''' and column_name like ''A%'' and column_id = '||l_counter||'; END;';

1169: l_counter := 1;
1170: WHILE l_counter <= l_number_of_index
1171: LOOP
1172:
1173: l_remote_index_string := 'BEGIN select column_name into :l_index_column from sys.all_tab_columns'||'@'||l_dblink||' where table_name = '''||l_view_name||''' and column_name like ''A%'' and column_id = '||l_counter||'; END;';
1174: Ams_Utility_Pvt.Write_Conc_log('get column name string = '||l_remote_index_string);
1175: BEGIN
1176: execute immediate l_remote_index_string using OUT l_index_column;
1177: Ams_Utility_Pvt.Write_Conc_log('index column = '||l_index_column);