APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 6438: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda

6434: INTO l_so_cnt
6435: FROM DUAL
6436: WHERE EXISTS(
6437: SELECT 1
6438: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
6439: WHERE wdd.lpn_id = l_lpn_id
6440: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
6441: AND wdd.organization_id = l_org_id
6442: AND wdd.delivery_detail_id = wda.parent_delivery_id);