Problem with Computed Column

Hi,
I am a newbie in Oracle and I am currently facing a problem with migrating my SQL statement to Oracle. The statement looks like this

create or replace view dbo."v_crm_events_detail_analysis" as
(select pd_type from dbo.party_dtl where pd_id=(select ceh_pt_id from
dbo.crm_events_hdr where ceh_id=ced_ceh_id) and pd_type in('C','P')) as Pd_Type,

(case when Pd_type='C' then 'Customer'

          when Pd_Type='P' then 'Prospect' end) as Party_type,

FROM dbo.Party

I got an error indicating INVALID identifier PD_TYPE. The error happens in my Case Section. Is it that Oracle cannot identified COmputed Columns in such circumstance or I am doing things wrongly? Or is there any workaroung ?

Thanks
Kwan Received on Sun Feb 27 2005 - 22:30:58 CST