Have you evaluated the explain plan? What do the table demographics look like? Your group by and qualify functions are certainly part of the performance issues. Can you narrow down the results with a SARG somehow to reduce the number of rows that need to be grouped and qualified?
Is this trying to find the latest date account_summary_dt by account_num and account_modifier_num?