DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 268: FROM wms_license_plate_numbers

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

Line 338: FROM wms_license_plate_numbers

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