APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on ALL_TABLES

Line 67: select owner from sys.all_tables

63: l_owner VARCHAR2(30);
64: l_view_name VARCHAR2(200);
65:
66: cursor c_view_exists(c_view_name VARCHAR2) is
67: select owner from sys.all_tables
68: where table_name = c_view_name;
69:
70: BEGIN
71: IF NVL(FND_PROFILE.VALUE('AMS_ENABLE_RECALC_AND_PREVIEW'), 'N') = 'Y'

Line 281: select 'Y' from sys.all_tables where table_name = l_view_name;

277: and qtemp.template_id = alias.template_id
278: and qtemp.list_src_type = types.source_type_code);
279:
280: cursor c_view_exists is
281: select 'Y' from sys.all_tables where table_name = l_view_name;
282:
283: l_synonym_exists varchar2(1);
284: cursor c_synonym_exists is
285: select 'Y' from sys.all_objects

Line 1151: l_check_table_string := 'begin select 1 into :l_exist from sys.all_tables'||'@'||l_dblink||' where table_name = '''||l_view_name||''' ;end;';

1147: retcode:= 0;
1148: -- SOLIN, Bug 3696553
1149: -- IF part is very up above
1150: ELSE
1151: l_check_table_string := 'begin select 1 into :l_exist from sys.all_tables'||'@'||l_dblink||' where table_name = '''||l_view_name||''' ;end;';
1152: Ams_Utility_Pvt.Write_Conc_log('l_check_table_string = '||l_check_table_string);
1153:
1154: BEGIN
1155: execute immediate l_check_table_string using OUT l_exist;