in new application how to populate display fields from a sql query

 hi All

I am relatively new to APEX. I want to create a basic form/report using a table. The basic form is created.

Now I am looking to populate two display fields that are required in the table based on the user selection from two other fields which are based on an lov.

For example, field1, field are lov based. field3 and field4 are both indivdually based on the entries in field1, field2 collectively.

In the display field3 the source is a sql statement as such

select life_cycle_id
from application_owner
where application_id=:P2_APPLICATION_ID