APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on ALL_TAB_COLUMNS

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

264: ) tab3
265: where master_source_type_flag = 'N';
266:
267: cursor c_index_columns is
268: select column_name from sys.all_tab_columns where table_name = l_view_name
269: and column_name not in (
270: select flds.source_column_name
271: from ams_list_src_fields flds ,AMS_QUERY_ALIAS alias,ams_list_src_types types,
272: ams_query_template_all qtemp

Line 1226: 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;';

1222: execute immediate l_remote_create_synonym;
1223: Ams_Utility_Pvt.Write_Conc_log('Synonym created. ');
1224:
1225: -- create index for remote table?
1226: 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;';
1227: Ams_Utility_Pvt.Write_Conc_log('l_remote_index_string = '||l_remote_index_string);
1228: BEGIN
1229: execute immediate l_remote_index_string using OUT l_number_of_index;
1230: Ams_Utility_Pvt.Write_Conc_log('number of index = '||l_number_of_index);

Line 1239: 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;';

1235: l_counter := 1;
1236: WHILE l_counter <= l_number_of_index
1237: LOOP
1238:
1239: 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;';
1240: Ams_Utility_Pvt.Write_Conc_log('get column name string = '||l_remote_index_string);
1241: BEGIN
1242: execute immediate l_remote_index_string using OUT l_index_column;
1243: Ams_Utility_Pvt.Write_Conc_log('index column = '||l_index_column);