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