Revision 1c77d03f
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/BackgroundJob/CloseProjectsBelongingToClosedSalesOrders.pm | ||
|---|---|---|
|
SELECT oe.globalproject_id
|
||
|
FROM oe
|
||
|
WHERE (oe.globalproject_id IS NOT NULL)
|
||
|
AND (oe.customer_id IS NOT NULL)
|
||
|
AND NOT COALESCE(oe.quotation, FALSE)
|
||
|
AND oe.record_type = 'sales_order'
|
||
|
AND COALESCE(oe.closed, FALSE)
|
||
|
)
|
||
|
EOSQL
|
||
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt