APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_LEGS

Line 127: FROM WSH_DELIVERY_LEGS WDL

123: AND wdd.container_flag = 'N')
124: AND NOT EXISTS (
125: -- deliveries in consolidations are ineligible
126: SELECT 1
127: FROM WSH_DELIVERY_LEGS WDL
128: WHERE WDL.delivery_id = t.id
129: AND WDL.parent_delivery_leg_id IS NOT NULL
130: )
131: ORDER BY d.creation_date;