title: ad_zd_mview.upgrade subquery in column
body: <p>Maybe someone know workaround how to correctly execute ad_zd_mview.upgrade command with subquery in the column? Workaround with using a view instead of select query is not working.</p>
  <p>For example:</p>
  <pre><code>create or replace view test1 as
  select
    1 column1,
    (select
      2
     from
      dual) column2
  from
    dual;
  
  create or replace view test2# as
  select
    *
  from
    test1;
  
  begin
    ad_zd_mview.upgrade('APPS', 'TEST2');
  end;
  </code></pre>
  <p>Is getting error ORA-22818: subquery expressions not allowed here.</p>