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;