SELECT A.INV_CODE, A.COMP_CODE, A.GATE_PASS_NO EXCISE_INV_NO, A.INV_DATE, ROUND(B.AMOUNT), (SELECT ROUND(SUM(D.AMOUNT)) FROM SALES.SALES_FINAL_BILL_MASTER M, SALES.SALES_FINAL_BILL_QUALITY D WHERE M.FBILL_NO = D.FBILL_NO AND M.COMP_CODE = D.COMP_CODE AND M.FBILL_DATE > '31-MAR-09' AND D.INV_CODE = A.INV_CODE AND D.COMP_CODE = A.COMP_CODE) BILL_AMOUNT FROM SALES.SALES_EXCISE_INV_MASTER A, SALES.SALES_EXCISE_INV_QUALITY B WHERE A.INV_CODE = B.INV_CODE AND A.COMP_CODE = B.COMP_CODE AND A.INV_DATE > '31-MAR-09' AND ROUND(B.AMOUNT) <> (SELECT ROUND(SUM(D.AMOUNT)) FROM SALES.SALES_FINAL_BILL_MASTER M, SALES.SALES_FINAL_BILL_QUALITY D WHERE M.FBILL_NO = D.FBILL_NO AND M.COMP_CODE = D.COMP_CODE AND M.FBILL_DATE > '31-MAR-09' AND D.INV_CODE = A.INV_CODE AND D.COMP_CODE = A.COMP_CODE) AND A.SALE_TYPE_CODE LIKE DECODE(:SALE_TYPE_CODE, NULL, '%', :SALE_TYPE_CODE) AND A.COMP_CODE LIKE DECODE(:COMP_CODE, NULL, '%', :COMP_CODE) ORDER BY A.INV_CODE,A.COMP_CODE