DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 266: FROM wms_license_plate_numbers

262: FROM wms_lpn_contents wlc
263: WHERE wlc.inventory_item_id = prl.item_id
264: AND wlc.parent_lpn_id IN(
265: SELECT lpn_id
266: FROM wms_license_plate_numbers
267: START WITH lpn_id = p_lpn_id
268: CONNECT BY parent_lpn_id = PRIOR lpn_id
269: )
270: )

Line 336: FROM wms_license_plate_numbers

332: FROM wms_lpn_contents wlc
333: WHERE wlc.inventory_item_id = rsl.item_id
334: AND wlc.parent_lpn_id IN(
335: SELECT lpn_id
336: FROM wms_license_plate_numbers
337: START WITH lpn_id = p_lpn_id
338: CONNECT BY parent_lpn_id = PRIOR lpn_id
339: )
340: )