Oracle doesn't do Booleans, so rewrite 'NOT withdrawn' etc. as 'CAST(ITEM.WITHDRAWN AS INTEGER) = 0' and so on.