maxd

/*
 * Copyright (c) 2009, 2017, Oracle and/or its affiliates. All rights reserved.
 * ORACLE PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 *
 *
 *
 *
 *
 *
 *

andybak

SELECT * FROM "logistics_consignment"
WHERE NOT ("logistics_consignment"."id" IN
             (SELECT U0."id"
              FROM "logistics_consignment" U0
              LEFT OUTER JOIN "office_split" U1 ON (U0."id" = U1."departure_id")
              LEFT OUTER JOIN "office_booking" U2 ON (U1."booking_id" = U2."id")
              LEFT OUTER JOIN "office_split" U3 ON (U0."id" = U3."arrival_id")
              LEFT OUTER JOIN "office_booking" U4 ON (U3."booking_id" = U4."id")
              WHERE (U2."status" = quote
                     OR U4."status" = quote)))