Script to get the scheduled concurrent requests

SELECT request_id,

  user_concurrent_program_name

FROM apps.fnd_conc_req_summary_v fcr

where fcr.phase_code        = 'P'

and fcr.status_code            in ( 'I', 'Q' )