APPS.INV_UI_PROJECT_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 261: FROM wms_license_plate_numbers

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

Line 289: FROM wms_license_plate_numbers

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

Line 314: FROM wms_license_plate_numbers

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

Line 369: FROM wms_license_plate_numbers

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

Line 398: FROM wms_license_plate_numbers

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

Line 424: FROM wms_license_plate_numbers

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