APPS.EDW_ALTER_INDEXES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

Type CurTyp is Ref Cursor;stmt varchar2(100) := 'select table_owner from user_synonyms where table_name = :s1';

Line: 51

stmt varchar2(400) := ' SELECT column_name, index_name FROM all_ind_columns '||
              	' where table_name = :s1 AND table_owner= :s2';

Line: 85

	'SELECT status
	FROM all_indexes
	WHERE table_name = :s1 and
	table_owner = :s2 and index_name = :s3';

Line: 137

			--g_indexes.delete(counter);

Line: 220

SELECT distinct object_short_name from edw_attribute_properties
where nvl(level_name, 'null') = 'null';