Multiple Child Aggregation:
An eyeopener docuement on Multiple Child Aggregation here
What ive been critizing all along seems to be the best approach .. duhhhh....
The document only describes the scenario on SQL Server and so the performance on Oracle is still debatable ;)