APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 6111: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda

6107: INTO l_so_cnt
6108: FROM DUAL
6109: WHERE EXISTS(
6110: SELECT 1
6111: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
6112: WHERE wdd.lpn_id = l_lpn_id
6113: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
6114: AND wdd.organization_id = l_org_id
6115: AND wdd.delivery_detail_id = wda.parent_delivery_id);