Revision b2c069f6
Von Werner Hahn vor etwa 1 Jahr hinzugefügt
SL/DB/Manager/Part.pm | ||
---|---|---|
103 | 103 |
LEFT OUTER JOIN oe o ON (oi.trans_id = o.id) |
104 | 104 |
WHERE |
105 | 105 |
oi.parts_id = ? |
106 |
AND (NOT COALESCE(o.quotation, FALSE))
|
|
106 |
AND (o.record_type = 'purchase_order')
|
|
107 | 107 |
AND (NOT COALESCE(o.closed, FALSE)) |
108 | 108 |
AND (NOT COALESCE(o.delivered, FALSE)) |
109 | 109 |
AND (COALESCE(o.vendor_id, 0) <> 0) |
... | ... | |
116 | 116 |
LEFT OUTER JOIN oe o ON (oi.trans_id = o.id) |
117 | 117 |
WHERE |
118 | 118 |
oi.parts_id = ? |
119 |
AND (NOT COALESCE(o.quotation, FALSE))
|
|
119 |
AND (o.record_type = 'purchase_order')
|
|
120 | 120 |
AND (NOT COALESCE(o.closed, FALSE)) |
121 | 121 |
AND (NOT COALESCE(o.delivered, FALSE)) |
122 | 122 |
AND (o.vendor_id is not null) |
Auch abrufbar als: Unified diff
Dispostionsmanager Controller an record_type angepasst