X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fpart_export%2Fvitelity.pm;h=22f9ba7d7d2a1f2715dada8cc1e518612303c748;hp=0b6b81b27940cb65738aaa7619f5e1deb25e936f;hb=e9f2cb50f9508ef790e5a37ffe68b2bcecc68930;hpb=b9fee0a2939c7b19da44982ceaa513292c3a7cd8 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", })