I belive maxxx is talking about using global variables from PL/SQL package. If I'm mistaken ignore this message.

You can not reference package variables directly in a sql. But you can usePL/SQL function that returns the value of a package varible in the where clause of your wiev definition.

HTH,