Hi Thom,
Sorry for the reply.
I am coming from an SAP HANA background where CTEs are still evolving . We dont have the option of doing recursive CTE or rCTES (Frankly I was not aware that there existed something like rCTEs).
I tried to breakup your rCTE and did individual select statements.Obviously that did not work ..
BR
Arshad