Allen,
I find it a bit worrying, first to see the customer_no as a
hard-coded value, and second not to see any reference to a particular
customer appear in your in-line view that does a GROUP BY and seems to
process a reasonably big number of rows. Unless you have a single
customer, of course.
HTH
Stephane Faroult
-- //www.freelists.org/webpage/oracle-l