Revision 97eaf9e0
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/DB/Manager/Part.pm | ||
|---|---|---|
| 78 | 78 |
FROM orderitems oi |
| 79 | 79 |
LEFT JOIN oe ON (oi.trans_id = oe.id) |
| 80 | 80 |
WHERE (oi.parts_id IN ($placeholders)) |
| 81 |
AND (NOT COALESCE(oe.quotation, FALSE))
|
|
| 81 |
AND oe.record_type = 'purchase_order'
|
|
| 82 | 82 |
AND (NOT COALESCE(oe.closed, FALSE)) |
| 83 | 83 |
AND (NOT COALESCE(oe.delivered, FALSE)) |
| 84 |
AND (COALESCE(oe.vendor_id, 0) <> 0) |
|
| 85 | 84 |
GROUP BY oi.parts_id |
| 86 | 85 |
SQL |
| 87 | 86 |
|
Auch abrufbar als: Unified diff
Angebotsflag aus Datenbankzugriffen entfernt