APPS.AD_ZD_MVIEW dependencies on DUAL

Line 291: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvloglname||'" as select * from dual');

287: else
288: l_commentpart1 := 'COMMENT ON TABLE "'||p_owner||'"."'||l_mvloglname||'" is '''||l_mvlogddl||'''';
289: end if;
290:
291: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvloglname||'" as select * from dual');
292: exec(c_module, l_commentpart1);
293: if (length(l_mvlogddl) > 4000)
294: then
295: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvlogmname||'" as select * from dual');

Line 295: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvlogmname||'" as select * from dual');

291: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvloglname||'" as select * from dual');
292: exec(c_module, l_commentpart1);
293: if (length(l_mvlogddl) > 4000)
294: then
295: exec(c_module, 'create or replace view "'||p_owner||'"."'||l_mvlogmname||'" as select * from dual');
296: exec(c_module, l_commentpart2);
297: end if;
298: end install_mvlog;
299:

Line 606: -- GB: why are we selecting from dual?

602: end;
603:
604:
605: -- Get MVQ defintiion and comment
606: -- GB: why are we selecting from dual?
607: procedure get_mvq_definition(p_owner IN varchar2,
608: p_mvqname IN varchar2,
609: p_mvqdef OUT NOCOPY CLOB,
610: p_comment OUT NOCOPY CLOB)

Line 619: FROM dual;

615:
616: begin
617: SELECT dbms_metadata.get_ddl('VIEW', p_mvqname, p_owner)
618: INTO p_mvqdef
619: FROM dual;
620: exception
621: when others then
622: log(c_module, 'ERROR', 'Strange Exception '||p_owner||'.'||p_mvqname||' '||SQLCODE);
623: p_mvqdef := null;

Line 631: FROM dual;

627:
628: begin
629: SELECT dbms_metadata.get_dependent_ddl('COMMENT', p_mvqname, p_owner)
630: INTO p_comment
631: FROM dual;
632: exception
633: when others then
634: if (SQLCODE = -31608) then
635: p_comment := null;