DBA Data[Home] [Help]

APPS.WMS_SHIPPING_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 47: wms_license_plate_numbers wlpn

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
51: