projekt kivitendo

  LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)

  WHERE

    oi.parts_id = ?

    AND (NOT COALESCE(o.closed,    FALSE))

    AND (NOT COALESCE(o.delivered, FALSE))

    AND (COALESCE(o.vendor_id, 0) <> 0)

  LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)

  WHERE

    oi.parts_id = ?

    AND (NOT COALESCE(o.closed,    FALSE))

    AND (NOT COALESCE(o.delivered, FALSE))

    AND (o.vendor_id is not null)

    delivery_term_id        => $vendor->delivery_term_id,

    taxzone_id              => $vendor->taxzone_id,

    currency_id             => $vendor->currency_id,

  );

  my @order_items;