Report based on MV: Deliberately make the report fail if MV is out of date?
Why bother at all with a new column, when you can just check LAST_REFRESH_DATE in ALL_MVIEWS before executing the actual query.
ALL_MVIEWS
And there is basic/advanced query rewrite as well.