Code:
select * 
  from lot l,
       (select issueid, quantity
          from lot
         where createdate >= TO_DATE('06/16/2003','MM/DD/YYYY')
           and createdate < TO_DATE('06/18/2003','MM/DD/YYYY')
         group by issueid, quantity
        having count(1) > 1 ) d
 where l.issueid = d.issueid
   and l.quantity = d.quantity