APPS.WMS_SHIPPING_PUB dependencies on WSH_DELIVERY_DETAILS

Line 46: wsh_delivery_details lpn_wdd ,

42: CURSOR get_delivery_detail_id (l_delivery_id NUMBER)
43: IS
44: SELECT wlpn.outermost_lpn_id,wlpn.organization_id,wda.delivery_detail_id
45: FROM wsh_delivery_assignments_v wda ,
46: wsh_delivery_details lpn_wdd ,
47: wms_license_plate_numbers wlpn
48: WHERE wda.delivery_id = l_delivery_id
49: AND wda.parent_delivery_detail_id=lpn_wdd.delivery_detail_id
50: AND wlpn.lpn_id=lpn_wdd.lpn_id;--bug13500119