diff options
| author | ivan <ivan> | 2011-03-30 19:52:30 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-30 19:52:30 +0000 |
| commit | d75388b3f184892ba4b7b339567de19aec78e08e (patch) | |
| tree | d6b5a5a89f8b6fd268d0fbd1673f9e4d151634dd | |
| parent | 41e328867acb7a2b4a956bef497dbf95d833fb5f (diff) | |
fix package balance conditions, RT#11834
| -rw-r--r-- | FS/FS/cust_bill.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm index d8d6eb107..3944404a8 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -654,8 +654,8 @@ sub cust_bill_pay_pkg { 'table' => 'cust_bill_pay_pkg', 'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '. ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', - 'extra_sql' => ' WHERE invnum = '. $self->invnum. - " AND pkgnum = $pkgnum", + 'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum. + " AND cust_bill_pkg.pkgnum = $pkgnum", }); } @@ -698,8 +698,8 @@ sub cust_credit_bill_pkg { 'table' => 'cust_credit_bill_pkg', 'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '. ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', - 'extra_sql' => ' WHERE invnum = '. $self->invnum. - " AND pkgnum = $pkgnum", + 'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum. + " AND cust_bill_pkg.pkgnum = $pkgnum", }); } |