APPS.AS_SC_DENORM dependencies on ALL_SNAPSHOT_LOGS

Line 164: FROM all_snapshot_logs

160: l_schema_return BOOLEAN;
161:
162: cursor dr_obj is
163: SELECT 'drop materialized view log on '||log_owner||'.'||master sqlstmt
164: FROM all_snapshot_logs
165: WHERE (log_owner = l_oracle_schema and master in ('AS_PERIOD_DAYS','AS_SALES_CREDITS_DENORM','AS_MC_SALES_CREDITS_DEN'))
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