Find Scheduled concurrent programs

Here is the query through which we can find all the scheduled concurrent programs:

select a.request_id, b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date, c.EXECUTION_METHOD_CODE,
d.execution_file_name,d.execution_file_path
from apps.fnd_concurrent_requests a, apps.fnd_concurrent_programs_tl b, apps.fnd_concurrent_programs c,
apps.FND_EXECUTABLES d
where status_code in ('Q','I')
and a.concurrent_program_id = b.concurrent_program_id
and b.concurrent_program_id = c.concurrent_program_id
and c.application_id=d.application_id
and c.executable_id=d.executable_id
and a.requested_start_date > SYSDATE
and a.hold_flag = 'N'
order by 1;


also look at the below notes for further understanding:
How to Determine Scheduled Concurrent Requests [ID 170107.1]
What are the Meaning of the Codes in the STATUS_CODE and PHASE_CODE Columns of FND_CONCURRENT_REQUESTS Table? [ID 152209.1]
Status Code Incorrect for Scheduled Requests in FND_CONCURRENT_REQUESTS Table [ID 1054419.6]