It's that null number thing again like quantity available is never 0 but null. Always had to use NVL(field,0)