APPS.WMS_SHIPPING_INTERFACE_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 53: FROM wms_license_plate_numbers

49: license_plate_number
50: INTO l_lpn_context ,
51: x_outermost_lpn_id,
52: x_license_plate_number
53: FROM wms_license_plate_numbers
54: WHERE lpn_id = p_lpn_id;
55:
56: x_return_status := g_ret_status_success;
57:

Line 841: FROM wms_license_plate_numbers wlpn

837: SELECT 1
838: INTO l_delivery_status
839: FROM dual
840: WHERE EXISTS ( SELECT lpn_context
841: FROM wms_license_plate_numbers wlpn
842: , wms_shipping_transaction_temp wstt
843: WHERE wlpn.lpn_id = wstt.outermost_lpn_id
844: AND wstt.delivery_id = x_dlvy_trip_tbl(i).delivery_id
845: AND wlpn.lpn_context = 9 );