SELECT NARRATION, VCH_DATE, COMP_CODE, VCH_AMOUNT, COUNT(1)
FROM ACCOUNTS.ACCOUNTS_VOUCHER_MAST
WHERE AUTO_TRANS = 'T'
AND STATUS <> 'C'
AND VCH_DATE BETWEEN '01-APR-2010' AND '31-MAR-2011'
AND VCH_NO IN (SELECT VCH_NO FROM ACCOUNTS.ACCOUNTS_VOUCHER_DTLS WHERE ACC_CODE = '0000000000182')
HAVING COUNT(1) > 1
GROUP BY NARRATION, VCH_DATE, COMP_CODE, VCH_AMOUNT