summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--FS/FS/part_export/vitelity.pm1
1 files changed, 1 insertions, 0 deletions
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",
})