I want to use a constant for comparision in the where clause of the query used in view.

I tried using CTE like this but this too fails as after myCTE...