APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 678: FROM wsh_delivery_assignments wda,

674: CL.site_use_status = 'A' AND
675: CL.site_use_code = 'SHIP_TO' AND
676: ( CL.ORG_ID IS NULL OR CL.ORG_ID IN
677: ( SELECT first_value(wdd.org_id) over(ORDER BY COUNT(wdd.org_id) DESC ) AS ORG_ID
678: FROM wsh_delivery_assignments wda,
679: wsh_delivery_details wdd
680: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
681: wda.delivery_id = p_delivery_id AND
682: wdd.container_flag = 'N'