Revision 97eaf9e0
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/BackgroundJob/CloseProjectsBelongingToClosedSalesOrders.pm | ||
|---|---|---|
| 24 | 24 |
SELECT oe.globalproject_id |
| 25 | 25 |
FROM oe |
| 26 | 26 |
WHERE (oe.globalproject_id IS NOT NULL) |
| 27 |
AND (oe.customer_id IS NOT NULL) |
|
| 28 |
AND NOT COALESCE(oe.quotation, FALSE) |
|
| 27 |
AND oe.record_type = 'sales_order' |
|
| 29 | 28 |
AND COALESCE(oe.closed, FALSE) |
| 30 | 29 |
) |
| 31 | 30 |
EOSQL |
Auch abrufbar als: Unified diff
Angebotsflag aus Datenbankzugriffen entfernt