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);