Java Development Tools

sorry I am a bit new to ADF and I'm sure this is a common requirement but I could not find the solution anywhere.

I will use the HR schema to demonstrate my problem

How do I set up a search that allows using employee info to retrieve distinct department info without duplicate rows?

for example if I have a view object something like

WITH t
     AS (SELECT emp.first_name,
                emp.last_name,
                salary,
                hire_date,
                department_name,
                location_id
           FROM hr.employees emp JOIN HR.DEPARTMENTS USING (department_id))
SELECT DISTINCT department_name, location_id
  FROM t

is there a way that when I pick All Queriable Attributes and put it on the form the user can search for say the departments where exists employees whose last name start with A
without displaying the employee info in the table?
so the table would just show department_name and location_id.