APPS.AD_ZD_MVIEW dependencies on DBA_MVIEWS

Line 668: from dba_mviews

664: l_owner := trim(nvl(p_owner, l_appsname));
665:
666: -- Check if MV exists
667: select count(1) into l_mvexist
668: from dba_mviews
669: where owner=l_owner and mview_name=p_mview_name;
670:
671: -- Drop existing MV if it exists
672: if (l_mvexist = 1) then

Line 1099: FROM dba_mviews

1095:
1096: -- Check if MV exists (it might)
1097: SELECT count(1)
1098: INTO l_mv_exist
1099: FROM dba_mviews
1100: WHERE owner=l_owner and mview_name=p_mvname;
1101:
1102: if (l_mv_exist = 0) then
1103:

Line 1118: from dba_mviews

1114:
1115: -- Get MV query text into CLOB
1116: insert into ad_zd_clob(owner, name, query)
1117: select owner, mview_name, to_lob(query)
1118: from dba_mviews
1119: where owner=l_owner and mview_name=p_mvname;
1120:
1121: select query into l_mv_text
1122: from ad_zd_clob

Line 1864: from dba_mviews m

1860: -- MVs to upgrade
1861: cursor C_MVS is
1862: select m.owner owner,
1863: m.mview_name name
1864: from dba_mviews m
1865: where m.owner in
1866: ( select oracle_username from fnd_oracle_userid
1867: where read_only_flag in ('A', 'E', 'U', 'B') )
1868: and not exists