procedure_4

   v_sql:= ' with basetab as (
    select '|| v_date|| ' DTIME,nvl(a.TEST1,0) TEST1,nvl(a.TEST2,0) TEST2,nvl(b.TEST3,0) TEST3,nvl(a.TEST4,0) TEST4,nvl(d.TEST5,0) TEST5,nvl(a.TEST6*a.TEST7,0) TEST6,nvl(c.TEST8,0) TEST8,nvl(c.TEST9,0) TEST9,nvl(c.TEST10,0) TEST10
             from  '|| v_tablename|| ' a,T_PROJECT_RETENTION b,T_PROJECT_REVENUE_D c,T_TEST_D d
             where   a.selectid=b.selectid  and a.selectid=c.selectid  and a.selectid=d.selectid
                     and a.RELselect = c.RELselect  and a.RELselect = d.RELselect
                               '||v_condition|| '
                               '||v_filter||' ),
              basetab2  as(
              select  * from basetab
              union all
              '|| v_condition2||' ),
               basetab3 as (select DTIME,sum(TEST1) TEST1,sum(TEST2) TEST2,sum(TEST3) TEST3,sum(TEST4) TEST4,sum(TEST5) TEST5,sum(TEST6) TEST6,sum(TEST8) TEST8,sum(TEST9) TEST9,sum(TEST10) TEST10 from basetab2
                         group by  DTIME  order by  DTIME )
              select  DTIME,TEST1,TEST2,TEST3,TEST4,TEST5,TEST6,TEST8,TEST9,TEST10
                      from   basetab3
                       where rownum<= '''||v_showNum||'''
                              ' ;

     open p_cur for v_sql ;