nikimiki7

SELECT t1.* 
  FROM rpm_future_retail t1
  INNER JOIN (
      select item, location, MAX(ACTION_DATE) action_date 
        from rpm_future_retail
        group by item, location 
        HAVING MAX(action_date) < SYSDATE order by item
    ) t2 ON (t1.item = t2.item and t1.location = t2.location and t1.action_date = t2.action_date)