SELECT xxx FROM view runs much slower than SELECT xxx from underlying query

[mike9]

Have a look at the explain plan of your 2 queries and you will see why one is slower as the other.
To see the explain plan execute SET AUTOTRACE ON in SQL*Plus.

HTH
Mike