Hi,

> So, where do you want OR and where do you want AND?

Your posting gave me an idea. The following query give the correct answers (the one in my previous posting does not).
With Recursive
RecurseCGS as
(
Select ID from CGS_Structure
where ID = :ID_RootCGS
Union all
Select Child.ID from CGS_Structure Child, RecurseCGS Parent
where Child.Parent_ID = Parent.id
)
select p.ID, p.BIZTYPE_DESCRIPTION, p.CostingType_Description, p.Description, p.CGS_Description, p.Date_Closing,
p.TOTAL_REVENUE, p.EXCHANGE_RATE, p.CGSSHARE_PCT from V_BD_Biz_Prim p, RecurseCGS
where (p.BIZTYPE_ID = :BizType_ID and p.CGS_ID = RecurseCGS.ID)
and (p.date_closing is null
or (p.date_closing between :DateA and :DateB
and coalesce(p.total_revenue,0) * coalesce(p.exchange_rate,0) * coalesce(p.cgsshare_pct,0) = 0))
order by p.BizType_Description, p.CGS_Description, p.Date_Closing desc, p.ID


Regards,

Nols Smit


[Non-text portions of this message have been removed]