SELECT MONRR, SUM(RCV),SUM(ISS) FROM
 (SELECT TO_CHAR(B.SR_DATE,'MMRRRR') MONRR ,SUM(A.STORE_AMT) RCV,SUM(0) ISS 
 FROM STORES_SR_DTLS A, STORES_SR_MAST B
 WHERE A.SR_NO = B.SR_NO
 AND A.COMP_CODE = B.COMP_CODE
 AND A.COMP_CODE = :PCOMP
 AND B.SR_DATE BETWEEN (SELECT MAX(STOCK_TAKING_DATE)FROM STORES.STORES_OPBAL WHERE COMP_CODE = :PCOMP) AND :PDATE
 GROUP BY TO_CHAR(B.SR_DATE,'MMRRRR')
 UNION ALL
 SELECT TO_CHAR(ISSUE_DATE,'MMRRRR') MONRR,SUM(0) RCV,SUM(ROUND(ISSUE_QTY*STORES.FN_ITEM_WISE_RATE(ITEM_CODE,ISSUE_DATE,COMP_CODE),2)) ISS
 FROM STORES_ISSUE_DTLS
 WHERE COMP_CODE = :PCOMP
 AND CAN_FLAG = 'N'
 AND ISSUE_DATE BETWEEN (SELECT MAX(STOCK_TAKING_DATE)FROM STORES.STORES_OPBAL WHERE COMP_CODE = :PCOMP) AND :PDATE
 GROUP BY TO_CHAR(ISSUE_DATE,'MMRRRR')) X
 GROUP BY MONRR
 ORDER BY 1
 
 SELECT SUM(OP_VALUE) FROM STORES.STORES_OPBAL
 WHERE COMP_CODE = :PCOMP
 AND STOCK_TAKING_DATE = (SELECT MAX(STOCK_TAKING_DATE)FROM STORES.STORES_OPBAL WHERE COMP_CODE = :PCOMP);