How to Find Scheduled Concurrent Program

Below Query will Fetch all the details for a scheduled concurrent program.

SELECT a.requested_by, 
       a.status_code, 
       a.phase_code, 
       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  a.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; 

Query For Finding schedules for a particular program

SELECT a.requested_by, 
       a.status_code, 
       a.phase_code, 
       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  a.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’ 
       AND b.user_concurrent_program_name = ‘&Program_Full_Name’ 
ORDER  BY 1;