APPS.AD_ZD_MVIEW dependencies on DBA_TAB_COMMENTS

Line 321: FROM dba_tab_comments

317: if (l_exist = 0)
318: then
319: SELECT count(1)
320: INTO l_exist
321: FROM dba_tab_comments
322: WHERE owner=p_owner
323: AND table_name=get_mvq_name(p_mview_name, g_mvl_char)
324: AND table_type='VIEW';
325:

Line 330: FROM dba_tab_comments

326: if (l_exist > 0)
327: then
328: SELECT nvl(trim(comments), ' ')
329: INTO l_mvlogddlpart1
330: FROM dba_tab_comments
331: WHERE owner=p_owner
332: AND table_name=get_mvq_name(p_mview_name, g_mvl_char)
333: AND table_type='VIEW';
334: end if;

Line 338: FROM dba_tab_comments

334: end if;
335:
336: SELECT count(1)
337: INTO l_exist
338: FROM dba_tab_comments
339: WHERE owner=p_owner
340: AND table_name=get_mvq_name(p_mview_name, g_mvm_char)
341: AND table_type='VIEW';
342:

Line 347: FROM dba_tab_comments

343: if (l_exist > 0)
344: then
345: SELECT nvl(trim(comments), ' ')
346: INTO l_mvlogddlpart2
347: FROM dba_tab_comments
348: WHERE owner=p_owner
349: AND table_name=get_mvq_name(p_mview_name, g_mvm_char)
350: AND table_type='VIEW';
351: end if;