SELECT Trunc(booking_date), Count(1) AS cnt
-- SELECT *
  FROM AcmVoucher v
  JOIN AcmVoucherType vt
    ON v.voucher_type_id = vt.id
 WHERE v.erp_target_1 = 0
   AND v.voucher_state_id=1000
   AND BITAND(vt.flags, 2) = 0
GROUP BY Trunc(booking_date)
ORDER BY Trunc(booking_date)
SELECT Trunc(booking_date), Count(1) AS cnt
-- SELECT *
  FROM AcmVoucher v
  JOIN AcmVoucherType vt
    ON v.voucher_type_id = vt.id
 WHERE v.erp_target_1 = 0
   AND v.voucher_state_id=1000
   AND BITAND(vt.flags, 2) = 0
GROUP BY Trunc(booking_date)
ORDER BY Trunc(booking_date)
SELECT Trunc(booking_date), Count(1) AS cnt
-- SELECT *
  FROM AcmVoucher v
  JOIN AcmVoucherType vt
    ON v.voucher_type_id = vt.id
 WHERE v.erp_target_1 = 0
   AND v.voucher_state_id=1000
   AND BITAND(vt.flags, 2) = 0
GROUP BY Trunc(booking_date)
ORDER BY Trunc(booking_date)