summaryrefslogtreecommitdiff
path: root/FS/FS
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2017-04-26 16:08:47 -0700
committerIvan Kohler <ivan@freeside.biz>2017-04-26 16:08:47 -0700
commite9f2cb50f9508ef790e5a37ffe68b2bcecc68930 (patch)
tree7e84b74351d1a0890cfc1eb659c30cf7cfc252e8 /FS/FS
parentb9fee0a2939c7b19da44982ceaa513292c3a7cd8 (diff)
fix freeside-daily error checking LNP status, RT#75736, RT#73618
Diffstat (limited to 'FS/FS')
-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 0b6b81b..22f9ba7 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",
})