Dima, Would that be a function based index? How about an additional index on rcqtr.quarter , rcqtr.rcqtr_num ?
Would something like
SELECT a.quarter, max(b.rcqtr_num) over (partition by b.rcqtr_num) FROM rcqtr A, rcprod11 B
WHERE a.rcqtr_num = b.rcqtr_num