select i.invoice_nr, i.organization_id, i.parent_invoice_id, i.invoice_nr,
i.total_amount, i.recipient_id, i.contact_id, i.organization_id
from iv_invoices i, cr_items ii
where ii.latest_revision = i.invoice_id
and ii.item_id = :invoice_id
update cr_items
set publish_status = 'expired'
where item_id = (select item_id from cr_revisions where revision_id = :file_id)