From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 26 Apr 2017 23:08:47 +0000 (-0700)
Subject: fix freeside-daily error checking LNP status, RT#75736, RT#73618
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=e9f2cb50f9508ef790e5a37ffe68b2bcecc68930

fix freeside-daily error checking LNP status, RT#75736, RT#73618
---

diff --git a/FS/FS/part_export/vitelity.pm b/FS/FS/part_export/vitelity.pm
index 0b6b81b27..22f9ba7d7 100644
--- a/FS/FS/part_export/vitelity.pm
+++ b/FS/FS/part_export/vitelity.pm
@@ -478,6 +478,7 @@ sub check_lnp {
 
   foreach my $svc_phone (
     qsearch({ 'table'     => 'svc_phone',
+              'addl_from' => 'LEFT JOIN cust_svc USING (svcnum)',
               'hashref'   => {lnp_status=>'portingin'},
               'extra_sql' => "AND svcpart $in_svcpart",
            })