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