select
distinct to_char(iv.due_date, 'MM') as iv_month
from
iv_invoices iv,
acs_objects o
where
iv.recipient_id = o.object_id
$extra_query
[template::list::filter_where_clauses -and -name iv_months]
select
count(invoice_id)
from
iv_invoices
where
to_char(due_date, 'MM') = :iv_month
$extra_query
select
sum(total_amount)
from
iv_invoices
where
to_char(due_date, 'MM') = :iv_month
$extra_query