If I remember right, it was some kind of nasty case statement combining NVL and debit and credit amounts to look where it didn't equal 0 on the overall transaction