From e9f2cb50f9508ef790e5a37ffe68b2bcecc68930 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 26 Apr 2017 16:08:47 -0700
Subject: [PATCH] fix freeside-daily error checking LNP status, RT#75736,
 RT#73618

---
 FS/FS/part_export/vitelity.pm | 1 +
 1 file changed, 1 insertion(+)

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",
            })
-- 
2.11.0