Query with join

One possible reason I could think of is you can pass variables to the procedure and find your query to work on them . If its a view , the filtering could be done on top of reocrd retrievals only ( as far as I have discovered DS , I didnt find a way of passing variables - either bind or literal to the query).

Does that make sense ?