Materialized View

I am getting an error when I run the following query can any one help me

create materialized view mv_bigtab as
select A.DLQ_STATUS,

       count(*) Count,
       nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
       T.MONTHS_DUE_TD < F.MONTHS_DUE and
       T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
       and A.DLQ_STATUS=F.DLQ_STATUS and A.DLQ_STATUS=T.DLQ_STATUS),0)
Stab,
       nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
       T.MONTHS_DUE_TD > F.MONTHS_DUE and
       T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
       and A.DLQ_STATUS>F.DLQ_STATUS  and A.DLQ_STATUS=T.DLQ_STATUS
),0) Rf,
       nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
       T.MONTHS_DUE_TD < F.MONTHS_DUE and
       T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
       and A.DLQ_STATUS<F.DLQ_STATUS  and A.DLQ_STATUS=T.DLQ_STATUS),0)
Rb,
       A.agency_code,
       A.cas_code
from
	almst A,collhist C
	where
	A.LOAN_NO=C.LOAN_NO and A.ACC_CLOSED <>'C'
group by
	A.agency_code,A.cas_code,A.DLQ_STATUS

Regards
Don Received on Wed May 10 2006 - 13:19:43 CDT