264: FROM wms_lpn_contents wlc
265: WHERE wlc.inventory_item_id = prl.item_id
266: AND wlc.parent_lpn_id IN(
267: SELECT lpn_id
268: FROM wms_license_plate_numbers
269: START WITH lpn_id = p_lpn_id
270: CONNECT BY parent_lpn_id = PRIOR lpn_id
271: )
272: )
334: FROM wms_lpn_contents wlc
335: WHERE wlc.inventory_item_id = rsl.item_id
336: AND wlc.parent_lpn_id IN(
337: SELECT lpn_id
338: FROM wms_license_plate_numbers
339: START WITH lpn_id = p_lpn_id
340: CONNECT BY parent_lpn_id = PRIOR lpn_id
341: )
342: )