SQL Query to find the scheduled or on hold concurrent request

Use the following query to find the scheduled or on hold concurrent request:

SELECT request_id
  FROM fnd_concurrent_requests
 WHERE status_code IN('Q', 'I') AND requested_start_date > SYSDATE AND hold_flag = 'N';

 

Output: