Hi Erik,
first time ever eView let me down and I figured it was my SELECT statement. But this puppy runs just fine to generate a cursor or programmatically CREATE SQL VIEW AS... Yet when I paste my SQL statement (less line continuations as shown below) into eView it tells me:

"eView cannot use the SQL below to redefine the view because the SQL is invalid"

I figure it either doesn't like multiple UNIONs, or like it's maker it doesnt like views based on views (duck) which is BTW unavoidable here unfortunately. Any thoughts? Mucho TIA!

SELECT Lv_rates_summary_schedc.audit_id,  
Lv_rates_summary_schedc.total AS admin_total,  
0000000000000000 AS rescare_total,  
0000000000000000 AS otherres_total,  
0000000000000000 AS retax_total  
FROM nis!lv_rates_summary_schedc  
WHERE UPPER(Lv_rates_summary_schedc.costcenter) = 'ADMINISTRATIVE'  
UNION  
SELECT Lv_rates_summary_schedc.audit_id,  
0000000000000000 AS admin_total,  
Lv_rates_summary_schedc.total AS rescare_total,  
0000000000000000 AS otherres_total,  
0000000000000000 AS retax_total  
FROM nis!lv_rates_summary_schedc  
WHERE UPPER(Lv_rates_summary_schedc.costcenter) = 'RESIDENT CARE'  
UNION  
SELECT Lv_rates_summary_schedc.audit_id,  
0000000000000000 AS admin_total,  
0000000000000000 AS rescare_total,  
Lv_rates_summary_schedc.total AS otherres_total,  
0000000000000000 AS retax_total  
FROM nis!lv_rates_summary_schedc  
WHERE UPPER(Lv_rates_summary_schedc.costcenter) = 'OTHER RESIDENT RELATED'  
UNION  
SELECT Lv_rates_summary_schedc.audit_id,  
0000000000000000 AS admin_total,  
0000000000000000 AS rescare_total,  
0000000000000000 AS otherres_total,  
Lv_rates_summary_schedc.total AS retax_total  
FROM nis!lv_rates_summary_schedc  
WHERE UPPER(Lv_rates_summary_schedc.costcenter) = 'REAL ESTATE TAXES'