User is issuing below query.

create table wilson2a
as select cpolicypfx, cpolicyno, criskstate, cpecode, nclaimoffc, nclaimno, nclaimsuff,
nrtline, NOCCURDATE, NCMADEDATE, CMINORCO, cmajorline,CBORISCODE, CFILLER1, creinsco, caccountid,
sum(nvl(npayment,0)) npayment,sum(nvl(nreserve,0)) nreserve,sum(nvl(npaidtodat,0)) npaidtodat,
sum(nvl(nopencount,0)) nopencount, sum(nvl(ncwpcount,0)) ncwpcount,
sum(nvl(ncnpcount,0)) ncnpcount
from homesupp a, homemain b where cpolicyno in
('1951726','5969327','9086977','9130806','9131869','9170162','9170171','9170223','9195863','9196064' ,
'9196103','9259702','9259743','9259750','9259783','9259786','9259795','9259859','9259865','9259926',
'9259965','9260213','9260516','9260517','9260521','9260529','9260563','9260570','9260577','9260700',
'9260719','9260762','9260770','9260771','9260810','9260816','9260841','9260853','9260857','9260886',
'C148574','C148579','C148581','C148582','C148588','C148596','C148597','C148601','C148611','C148642')
and a.nrecnum=b.nrecnum
group by cpolicypfx, cpolicyno, criskstate, cpecode, nclaimoffc, nclaimno, nclaimsuff,
nrtline, NOCCURDATE, NCMADEDATE, CMINORCO, cmajorline, CBORISCODE, CFILLER1, creinsco, caccountid;