Dispensed Items from Web

SELECT
  DI.DISPENSE_ID,
  DI.ITEM_ID,
  I.Created_By,
  DI.*
FROM dispense D
inner join DISPENSE_ITEMS DI ON D.DISPENSE_ID = DI.DISPENSE_ID
left join ITEMS I ON DI.DISPENSE_ITEM_ID = DI.ITEM_ID
WHERE
  ROWNUM < 10
  AND D.dispense_date >= TO_DATE('2015/03/01', 'yyyy/mm/dd')
  AND D.web_dispense = 1
ORDER BY
  DI.DISPENSE_ID, DI.DISPENSE_ITEM_ID