X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/c09536f461b4933a1813b2af5e17eb6214f7bf38..df601bd3fcca2c121c54f489e504dd676da75876:/SL/PE.pm diff --git a/SL/PE.pm b/SL/PE.pm index 9906a72d9..28f3ba5c1 100644 --- a/SL/PE.pm +++ b/SL/PE.pm @@ -172,7 +172,7 @@ sub pricegroups { my $first = 1; $where .= qq| AND id NOT IN (|; - foreach my $table (qw(invoice orderitems prices rmaitems)) { + foreach my $table (qw(invoice orderitems prices)) { $where .= "UNION " unless ($first); $first = 0; $where .= @@ -253,7 +253,7 @@ sub get_pricegroup { my @values = (); $query = qq|SELECT |; - foreach my $table (qw(invoice orderitems prices rmaitems)) { + foreach my $table (qw(invoice orderitems prices)) { $query .= " + " unless ($first); $first = 0; $query .= qq|(SELECT COUNT(*) FROM $table WHERE pricegroup_id = ?) |;