select i.invoice_nr, i.organization_id, i.parent_invoice_id, i.invoice_nr, i.total_amount, i.recipient_id, i.organization_id from iv_invoices i, cr_items ii where ii.latest_revision = i.invoice_id and ii.item_id = :invoice_id