SEQUENCE NUMBER NOT ALLOWED HERE
453745Sep 10 2007 — edited Sep 10 2007SELECT KPIALARM.NEXTVAL,S.* FROM(
SELECT T.* FROM(SELECT 'Subscribers with High Balances',
MSISDN,ACC_BALANCE,' WHERE UPPER(UNIV_FILE_NAME)=UPPER(''CLL.SMEP101.20070620095945.20070620100445.GZ'')
AND ACC_BALANCE >70000','ACC_BALANCE > 70000','FCT_OTT_IN','CLL.SMEP101.20070620095945.20070620100445.GZ','1',
'MSISDN',ROUND((ACC_BALANCE-70000)*100/70000,2),1
FROM FCT_OTT_IN
WHERE UPPER(UNIV_FILE_NAME)= UPPER('CLL.SMEP101.20070620095945.20070620100445.GZ') AND ACC_BALANCE > 70000)T
)S
GROUP BY S.MSISDN,S.ACC_BALANCE
WHAT IS THE WRONG IN MY QUERY IT RETURNS SEQUENCE NUMBER NOT ALLOWED HERE.