Revision 42926bf7
Von wernerh vor mehr als 1 Jahr hinzugefügt
| SL/DB/Manager/Part.pm | ||
|---|---|---|
| 103 | 103 |
orderitems oi |
| 104 | 104 |
LEFT OUTER JOIN oe o ON (oi.trans_id = o.id) |
| 105 | 105 |
WHERE |
| 106 |
( o.closed = 'F' OR |
|
| 107 |
o.closed IS NULL) AND |
|
| 108 |
oi.parts_id = ? AND |
|
| 109 |
o.vendor_id IS NOT NULL |
|
| 106 |
oi.parts_id = ? |
|
| 107 |
AND (NOT COALESCE(o.quotation, FALSE)) |
|
| 108 |
AND (NOT COALESCE(o.closed, FALSE)) |
|
| 109 |
AND (NOT COALESCE(o.delivered, FALSE)) |
|
| 110 |
AND (COALESCE(o.vendor_id, 0) <> 0) |
|
| 110 | 111 |
GROUP BY oi.parts_id |
| 111 | 112 |
SQL |
| 112 | 113 |
|
Auch abrufbar als: Unified diff
HMO: Dispositionsmanager Abfrage für bestellete offene Menge geändert