diff options
Diffstat (limited to 'LedgerSMB/OE.pm')
| -rw-r--r-- | LedgerSMB/OE.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/LedgerSMB/OE.pm b/LedgerSMB/OE.pm index 6294236b..f3838c13 100644 --- a/LedgerSMB/OE.pm +++ b/LedgerSMB/OE.pm @@ -83,8 +83,8 @@ sub transactions { m.name AS manager, o.curr, o.ponumber FROM oe o JOIN $form->{vc} ct ON (o.$form->{vc}_id = ct.id) - LEFT JOIN employees e ON (o.employee_id = e.id) - LEFT JOIN employees m ON (e.managerid = m.id) + LEFT JOIN employee e ON (o.employee_id = e.id) + LEFT JOIN employee m ON (e.managerid = m.id) LEFT JOIN exchangerate ex ON (ex.curr = o.curr AND ex.transdate = o.transdate) WHERE o.quotation = ? @@ -138,7 +138,7 @@ sub transactions { } $query .= qq| - LEFT JOIN employees e ON (o.employee_id = e.id) + LEFT JOIN employee e ON (o.employee_id = e.id) LEFT JOIN exchangerate ex ON (ex.curr = o.curr AND ex.transdate = o.transdate) @@ -765,7 +765,7 @@ sub retrieve { o.ponumber FROM oe o JOIN $form->{vc} vc ON (o.$form->{vc}_id = vc.id) - LEFT JOIN employees e ON (o.employee_id = e.id) + LEFT JOIN employee e ON (o.employee_id = e.id) LEFT JOIN department d ON (o.department_id = d.id) WHERE o.id = ?|; $sth = $dbh->prepare($query); |