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;