APPS.AS_SC_DENORM dependencies on USER_SNAPSHOTS

Line 170: FROM user_snapshots

166: --or (log_owner = 'JTF' and master in ('JTF_RS_REP_MANAGERS','JTF_RS_GROUP_USAGES'))
167: or (log_owner = l_apps_schema and master in ('ASF_SC_BIN_MV','ASF_SCBINLD_MV'))
168: UNION ALL
169: SELECT 'drop materialized view '||owner||'.'||name
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