Revision e5e8dfae
Von Sven Schöling vor fast 7 Jahren hinzugefügt
| SL/Helper/ShippedQty.pm | ||
|---|---|---|
| 61 | 61 |
ORDER BY oi.trans_id, oi.position |
| 62 | 62 |
|
| 63 | 63 |
my $stock_fill_up_doi_query = <<''; |
| 64 |
SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, i.qty, i.unit
|
|
| 64 |
SELECT doi.id, doi.delivery_order_id, doi.position, doi.parts_id, doi.description, doi.reqdate, doi.serialnumber, i.qty, p.unit
|
|
| 65 | 65 |
FROM delivery_order_items doi |
| 66 | 66 |
INNER JOIN parts p ON p.id = doi.parts_id |
| 67 | 67 |
INNER JOIN delivery_order_items_stock dois ON dois.delivery_order_item_id = doi.id |
Auch abrufbar als: Unified diff
SL::Helper::ShippedQty: SQL Fehler im stock_fill_up query