APPS.AD_ZD_MVIEW dependencies on DBA_MVIEW_LOGS

Line 274: FROM dba_mview_logs

270: l_mvloglname := get_mvq_name(p_mview_name, g_mvl_char);
271: l_mvlogmname := get_mvq_name(p_mview_name, g_mvm_char);
272: SELECT log_table
273: INTO l_ctblname
274: FROM dba_mview_logs
275: WHERE master=p_mview_name
276: AND log_owner=p_owner;
277:
278: l_mvlogddl := dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG',

Line 313: FROM dba_mview_logs

309: log(c_module, 'EVENT', 'Recreating MV Log');
310:
311: SELECT count(1)
312: INTO l_exist
313: FROM dba_mview_logs
314: WHERE log_owner=p_owner
315: AND master=p_mview_name;
316:
317: if (l_exist = 0)

Line 535: from dba_mview_logs

531: end if;
532:
533: -- If MVLog exist then install mvlog marker
534: select count(1) into l_exist
535: from dba_mview_logs
536: where log_owner=p_owner and master=p_mview_name;
537:
538: if (l_exist > 0) then
539: install_mvlog(p_owner, p_mview_name);

Line 1692: FROM dba_mview_logs

1688: for ptbl in ptbls
1689: loop
1690: SELECT count(1)
1691: INTO l_mvlog_exist
1692: FROM dba_mview_logs
1693: WHERE log_owner=ptbl.owner
1694: AND master=ptbl.name;
1695:
1696: log(c_module, 'STATEMENT', 'Checking count for '||