MATERIALIZED VIEW FOR PIVOTING TABLE QUERY

I NEED TO CREATE MATERIALIZED VIEW FOR PIVOTING TABLE QUERY ..

                                REFRESH = FAST

I CAN NOT CREATE IT BECAUSE QUERY IS "TOO COMPLEX".. IS IT?? DOCUMENTATION SAYS THAT MAX AND MIN FUNCTION CAN'T BE USED IN QUERY FOR MATERIALIZED VIEW (FAST REFRESHABLE)

--***********************************************************************

CREATE MATERIALIZED VIEW LOG ON COMBINATION_ATRIBUT WITH ROWID
/

CREATE MATERIALIZED VIEW MV_COMBINATION

       PARALLEL
       BUILD IMMEDIATE
       REFRESH FAST
       ON DEMAND
       AS

SELECT COMBINATION, MAX(DECODE(ATRIBUT,'Colour',VRIJEDNOST,NULL)) Colour,

MAX(DECODE(ATRIBUT,'Year',VRIJEDNOST,NULL)) Year,

MAX(DECODE(ATRIBUT,'Class',VRIJEDNOST,NULL)) Class,

MAX(DECODE(ATRIBUT,'Weigh',VRIJEDNOST,NULL)) Weigh,

MAX(DECODE(ATRIBUT,'Length',VRIJEDNOST,NULL)) Length

FROM COMBINATION_ATRIBUT GROUP BY COMBINATION
/

--***********************************************************************