Prompting For Input

How can I design my Views in SQL using enterprise manager for it to prompt for input when i run it.

I want me view to return results from my database based on the input variable.

Thank you in advance.