X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_hardware.cgi;fp=httemplate%2Fsearch%2Fsvc_hardware.cgi;h=085d7500a4626ad84e20af93d2650f7c0b0aee95;hb=fed12e8214a8a951377961ccbe7a09171b1e38c2;hp=ec09be82bcbf39a30d76f4cd6bca22161af5039b;hpb=fc8d730d0a7b31b617c963c5619bd3f45c5c3eb6;p=freeside.git

diff --git a/httemplate/search/svc_hardware.cgi b/httemplate/search/svc_hardware.cgi
index ec09be82b..085d7500a 100644
--- a/httemplate/search/svc_hardware.cgi
+++ b/httemplate/search/svc_hardware.cgi
@@ -44,8 +44,8 @@ die "access denied"
 my $addl_from = '
  LEFT JOIN cust_svc  USING ( svcnum  )
  LEFT JOIN part_svc  USING ( svcpart )
- LEFT JOIN cust_pkg  USING ( pkgnum  )
- LEFT JOIN cust_main USING ( custnum )
+ LEFT JOIN cust_pkg  USING ( pkgnum  )'.
+ FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg').'
  LEFT JOIN hardware_type USING ( typenum )';
 
 my @extra_sql;