Passing Parameters to the Sub-Query/Inner Query
Hello
We are using Discoverer Admin/Desktop - 9.0.2
How could I pass value to the parameters to the Inner-Query/Sub-Query in the Discoverer
Something like this
:p_join_date in the following query
SELECT fu.user_name, fu.description, emp_master.last_name
FROM fnd_user fu,
(SELECT employee_number, person_id, last_name
FROM per_people_f
WHERE effective_start_date >= :p_join_date) emp_master
WHERE emp_master.person_id = fu.employee_id
Thank you