fix display bug, RT#8524

[freeside.git] / httemplate / search / part_pkg.html

diff --git a/httemplate/search/part_pkg.html b/httemplate/search/part_pkg.html
index 87237c7..d879c37 100644 (file)
--- a/httemplate/search/part_pkg.html
+++ b/httemplate/search/part_pkg.html
@@ -62,7 +62,7 @@ if (1) { #commission reports
       push @links, ''; #link to employee edit w/ACL?
       $align .= 'c';
 
-      push @order_by, 'otaker';
+      push @order_by, 'username';
 
       $title = 'Employee';
 
@@ -114,8 +114,8 @@ if (1) { #commission reports
   }
 
   my $from_cust_bill_pkg_where = "FROM cust_bill_pkg
-                                      LEFT JOIN ( cust_bill ) USING ( invnum )
-                                      LEFT JOIN ( cust_pkg  ) USING ( pkgnum )
+                                      LEFT JOIN cust_bill USING ( invnum )
+                                      LEFT JOIN cust_pkg  USING ( pkgnum )
                                     WHERE cust_bill_pkg.pkgnum > 0
                                       AND cust_bill._date >= $beginning
                                       AND cust_bill._date <= $ending         ";