DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_DELIVERY_DETAILS

Line 3151: from wsh_delivery_details wdd, wsh_delivery_assignments wda

3147:
3148: BEGIN
3149:
3150: select nvl(wda.delivery_id,999) into l_delivery_id
3151: from wsh_delivery_details wdd, wsh_delivery_assignments wda
3152: WHERE wda.delivery_detail_id(+) = wdd.delivery_detail_id AND ROWNUM < 2
3153: AND wdd.lpn_id IN
3154: ( select wlpn.lpn_id
3155: from wms_license_plate_numbers wlpn

Line 8823: FROM wsh_delivery_details_ob_grp_v wdd,

8819: BEGIN
8820:
8821: SELECT wda.delivery_id
8822: INTO l_delivery_id
8823: FROM wsh_delivery_details_ob_grp_v wdd,
8824: wsh_delivery_assignments wda
8825: WHERE wdd.lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
8826: WHERE outermost_lpn_id = (SELECT outermost_lpn_id
8827: FROM wms_license_plate_numbers