APPS.AD_ZD_MVIEW dependencies on AD_ZD_CLOB

Line 1111: delete from ad_zd_clob

1107: else
1108:
1109: log(c_module, 'STATEMENT', 'MV exists, checking definition');
1110:
1111: delete from ad_zd_clob
1112: where owner=l_owner and name in
1113: (p_mvname, get_mvq_name(p_mvname));
1114:
1115: -- Get MV query text into CLOB

Line 1116: insert into ad_zd_clob(owner, name, query)

1112: where owner=l_owner and name in
1113: (p_mvname, get_mvq_name(p_mvname));
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:

Line 1122: from ad_zd_clob

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
1123: where owner=l_owner and name=p_mvname;
1124:
1125: -- Get MVQ query text into CLOB
1126: insert into ad_zd_clob(owner, name, query)

Line 1126: insert into ad_zd_clob(owner, name, query)

1122: from ad_zd_clob
1123: where owner=l_owner and name=p_mvname;
1124:
1125: -- Get MVQ query text into CLOB
1126: insert into ad_zd_clob(owner, name, query)
1127: select owner, view_name, to_lob(text)
1128: from dba_views
1129: where owner=l_owner and view_name=l_mvq_name;
1130:

Line 1132: from ad_zd_clob

1128: from dba_views
1129: where owner=l_owner and view_name=l_mvq_name;
1130:
1131: select query into l_mvq_text
1132: from ad_zd_clob
1133: where owner=l_owner and name=l_mvq_name;
1134:
1135: -- Compare query text, process if different
1136: if (dbms_lob.compare(expand_query(l_mvq_text), l_mv_text) <> 0) then