SELECT TO_DATE(TO_CHAR(TRANS_DATE,'MMRRRR'),'MMRRRR') MON, ROUND(SUM(DECODE(TYPE,'C',VALUE,0)),2) RCV, ROUND(SUM(DECODE(TYPE,'I',VALUE,0)),2) ISS FROM STORES.STORES_ITEM_LEDGER WHERE COMP_CODE = :COMP_CODE AND TRANS_DATE between :START_DATE AND :END_DATE --AND STOCKPOINT_TYPE <> 98 GROUP BY TO_DATE(TO_CHAR(TRANS_DATE,'MMRRRR'),'MMRRRR') ORDER BY 1;