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