2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv
2810: , mtl_secondary_inventories msi
2811: WHERE msn.current_organization_id = p_current_organization_id
2812: AND msn.lpn_id IS NULL
2813: AND (msn.group_mark_id IS NULL
2814: OR msn.group_mark_id = -1