257: FROM wms_lpn_contents wlc
258: WHERE wlc.inventory_item_id = rsl.item_id
259: AND wlc.parent_lpn_id IN
260: ( SELECT lpn_id
261: FROM wms_license_plate_numbers
262: START WITH lpn_id = p_lpn_id
263: CONNECT BY parent_lpn_id = PRIOR lpn_id
264: )
265: )
285: FROM wms_lpn_contents wlc
286: WHERE wlc.inventory_item_id = rsl.item_id
287: AND wlc.parent_lpn_id IN
288: ( SELECT lpn_id
289: FROM wms_license_plate_numbers
290: START WITH lpn_id = p_lpn_id
291: CONNECT BY parent_lpn_id = PRIOR lpn_id
292: )
293: )
310: FROM wms_lpn_contents wlc
311: WHERE wlc.inventory_item_id = rsl.item_id
312: AND wlc.parent_lpn_id IN
313: ( SELECT lpn_id
314: FROM wms_license_plate_numbers
315: START WITH lpn_id = p_lpn_id
316: CONNECT BY parent_lpn_id = PRIOR lpn_id
317: )
318: )
365: FROM wms_lpn_contents wlc
366: WHERE wlc.inventory_item_id = prl.item_id
367: AND wlc.parent_lpn_id IN
368: ( SELECT lpn_id
369: FROM wms_license_plate_numbers
370: START WITH lpn_id = p_lpn_id
371: CONNECT BY parent_lpn_id = PRIOR lpn_id
372: )
373: )
394: FROM wms_lpn_contents wlc
395: WHERE wlc.inventory_item_id = prl.item_id
396: AND wlc.parent_lpn_id IN
397: ( SELECT lpn_id
398: FROM wms_license_plate_numbers
399: START WITH lpn_id = p_lpn_id
400: CONNECT BY parent_lpn_id = PRIOR lpn_id
401: )
402: )
420: FROM wms_lpn_contents wlc
421: WHERE wlc.inventory_item_id = prl.item_id
422: AND wlc.parent_lpn_id IN
423: ( SELECT lpn_id
424: FROM wms_license_plate_numbers
425: START WITH lpn_id = p_lpn_id
426: CONNECT BY parent_lpn_id = PRIOR lpn_id
427: )
428: )