Oracle 10.2 acting weird. Or is it me

Please check out the following query. The SQL isn\'t as bad as it looks. Basically, we have a fact table and some simple joins to some dimension tables. Then we have a join to a derived table, given t