APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_LEGS
Line 133: FROM WSH_DELIVERY_LEGS WDL
129: AND wdd.container_flag = 'N')
130: AND NOT EXISTS (
131: -- deliveries in consolidations are ineligible
132: SELECT 1 133: FROM WSH_DELIVERY_LEGS WDL 134: WHERE WDL.delivery_id = t.id
135: AND WDL.parent_delivery_leg_id IS NOT NULL
136: )
137: ORDER BY d.creation_date;