Oracle APEX Interactive report filter error

I have created 3 Oracle SQL tables with primary and foreign keys as specified in brackets below:

1. Application (PK: app_id)
2. Vendor (PK: vendor_id, FK :app_id referencing Application table)
3. Servers (PK: server_id, FK :app_id referencing Application table)

My requirement is that when I click on a single application record in the report, it should open all the servers and vendors associated with it on a new page.

In the application page, I have added a new column in SQL query and set the link to redirect to server page. I have added a hidden field(P5_NEW) in the server page and tried writing the below SQL query. Should I modify the query?

select application.application_id,SERVER_ID,
       APP_ID,
       etc...
  from SERVER, APPLICATION
where server.app_id=application.application_id and
  APPLICATION.APPLICATION_ID = :P5_NEW;

Also, please note that I have created an interactive report which displays all server records when the server is selected on the left menu on the home page.

I am not getting the correct output/records with the method I'm trying. Please let me know if further info/clarification is required. Thanks in advance and your help is much appreciated.

server page designer

application page designer

Report

In the first screenshot ("server page designer"), you're missing the Page items to submit property. Put P5_NEW in there. Otherwise, query doesn't know its value and returns invalid data.