APPS.AS_SC_DENORM dependencies on DBA_INDEXES

Line 174: FROM dba_indexes

170: FROM user_snapshots
171: WHERE name in ('ASF_SC_BIN_MV', 'ASF_SCBINMV_SUM_MV', 'ASF_SCBINLD_MV', 'ASF_SCBINLD_SUMMV', 'ASF_SCBIN_SUMMV')
172: UNION ALL
173: SELECT 'drop index '||owner||'.'||index_name
174: FROM dba_indexes
175: WHERE table_owner = l_apps_schema
176: and table_name in ('ASF_SCBINLD_SUMMV','ASF_SCBIN_SUMMV');
177:
178: ddl_curs integer;