select max(to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS')) as last_checkout
from iv_joined_invoices
select to_char(now(), 'YYYYMMDD_HH24MI') as today
select fr.content
from iv_invoices i, cr_items ci, cr_items fi, cr_revisions fr, acs_objects fo
where ci.latest_revision = i.invoice_id
and i.pdf_status = 'created'
and fi.item_id = i.pdf_file_id
and fr.revision_id = fi.latest_revision
and fo.object_id = fr.revision_id
and fo.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS')
order by i.organization_id, i.invoice_nr
select r.content as file_location
from cr_items i, cr_revisions r
where i.latest_revision = r.revision_id
and i.item_id = :file_id
insert into iv_joined_invoices (file_id, creation_date)
values (:file_id, now())
update iv_invoices
set pdf_status = 'sent'
where invoice_id in (select i.invoice_id
from iv_invoices i, cr_items ci, cr_items fi, acs_objects fo
where ci.latest_revision = i.invoice_id
and i.pdf_status = 'created'
and fi.item_id = i.pdf_file_id
and fo.object_id = fi.latest_revision
and fo.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS'))