> I guess that the use of ORDER BY applied on VIEWS is ok.
>
> eg. SELECT * from vVIEW ORDER BY VIEW.FIELD1

You shouldn't see this as applying an order by to a view, but as applying
an order by to (the result of) a query. That query just happens to only
reference a view.

Mark