select max(to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS')) as last_checkout
from iv_journals
select to_char(now(), 'YYYYMMDD_HH24MI') as today, to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as today_pretty
select iso_code, journal_code
from iv_journal_country_codes
select distinct i.recipient_id
from iv_invoices i, cr_items ii, acs_objects o
where i.invoice_id = ii.latest_revision
and o.object_id = ii.item_id
and i.status in ('billed', 'cancelled', 'paid')
and o.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS')
select i.invoice_nr, i.parent_invoice_id, i.recipient_id, i.total_amount, i.currency,
i.payment_days, i.vat, i.vat_percent, to_char(o.creation_date, 'MMYYYY') as invoice_period,
r.title as invoice_name, to_char(o.creation_date, 'DDMMYYYY') as invoice_date
from iv_invoices i, cr_revisions r, cr_items ii, acs_objects o
where i.invoice_id = r.revision_id
and r.revision_id = ii.latest_revision
and o.object_id = ii.item_id
and i.status in ('billed', 'cancelled', 'paid')
and o.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS')
select i.invoice_nr, i.recipient_id, i.total_amount, i.currency, i.amount_sum, i.vat,
to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as invoice_date
from iv_invoices i, cr_items ii, acs_objects o
where i.invoice_id = ii.latest_revision
and o.object_id = ii.item_id
and i.status in ('billed', 'cancelled')
and o.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS')
order by i.invoice_nr
select invoice_nr as parent_invoice_nr
from iv_invoices
where invoice_id = :parent_invoice_id
insert into iv_journals (file_id, creation_date)
values (:zip_file_id, now())