Refreshable on commit materialized view using MAX()
The MV_CAPABILITIES_TABLE.MSGTXT is wrong, what you really need to do is replace case with decode.
When I tried this on 11g I got the message CASE expressions present in materialized view. Changing it to use decode fixed it on both 10g and 11g.