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