关于oracle的问题。本人菜鸟，请高手指点下。

 vv_sqlcmd := 'insert into tsd_subs_points_'|| vv_month ||'(      '||
                 '            SUBS_PTS_ID,                '||--1
                 '            CURRENT_PTS,                '||--2
                 '            ACC_PTS,                    '||--3
                 '            SUBS_INSTANCE_ID,           '||--4
                 '            STATUS,                     '||--5
                 '            CONSUME_PTS,                '||--6
                 '            ONNET_PTS,                  '||--7
                 '            AWARD_PTS,                  '||--8
                 '            CREDIT_PTS)                 '||--9
                 ' select    b.SUBS_PTS_ID,               '||--1 
                 '           b.CURRENT_PTS,               '||--2 
                 '           a.ACC_PTS,                   '||--3 
                 '           a.SUBS_ID,                   '||--4 
                 '           a.STATUS,                    '||--5 
                 ' sum(decode(b.pts_typ_id,''消费'',''消费'',0)), '||--6
                 ' sum(decode(b.pts_typ_id,''在网'',''在网'',0)), '||--7 
                 ' sum(decode(b.pts_typ_id,''奖励'',''奖励'',0)), '||--8
                 ' sum(decode(b.pts_typ_id,''信用'',''信用'',0))  '||--9 
                 ' from      subs_points a,               '||
                 '           subs_typ_points b            '||
                 ' group by  b.pts_typ_id                 '||
                 ' where     a.subs_pts_id=b.subs_pts_id  ';
    execute immediate vv_sqlcmd;
    commit;
我知道group by 后面不能借where，但是我需要加后面的条件，请问应该怎么写啊。想给点分，可惜没有，谢谢好心人！！