I want to use a column alias in a where clause like the following:
select order_id,
decode(status, 'Held', '1 - Held', 'Shipped', '2 - Shipped) as ordstatus
from order_header
where ordstatus = '1 - Held'

I get 'invalid column name' on ordstatus. Any ideas would be appreciated.