Pass parameters to View in SQL or Oracle
Can you or can you not pass parameters to a view? Well, the short answer is no. A view is seen by the database (and should be considered by us) as a table.
Read article: Pass parameters to View in SQL or Oracle