We opted for a custom table to satisfy the requirement but this may be helpful to someone

Code:
SELECT   /*+ ORDERED */
         reqs.request_id, reqs.requested_start_date requested_start_date,
         reqs.phase_code,
         DECODE (reqs.phase_code,
                 'P', 'PENDING',
                 'R', 'RUNNING',
                 'C', 'COMPLETED',
                 reqs.phase_code
                ) phase_code_txt,
         reqs.status_code,
         DECODE (reqs.status_code,
                 'D', 'CANCELLED',
                 'Q', 'SCHEDULED',
                 'I', 'SCHEDULED',
                 'R', 'RUNNING',
                 'X', 'TERMINATED',
                 'E', 'ERROR',
                 'C', 'COMPLETED NORMAL',
                 reqs.status_code
                ) status_code_txt,
         reqs.hold_flag, reqs.cancel_or_hold, usr.user_name,
         prg.user_concurrent_program_name prg_name, argument_text args,
         SUBSTR (argument_text, 1, INSTR (argument_text, ',') - 1) arg1
    FROM apps.fnd_user usr,
         apps.fnd_concurrent_requests reqs,
         apps.fnd_concurrent_programs_tl prg
   WHERE reqs.phase_code IN ('P', 'R')
-- and   reqs.request_id = 20234093
     AND reqs.concurrent_program_id = prg.concurrent_program_id
     AND prg.user_concurrent_program_name LIKE
                                           '%'
                                              --'%XYZ_PRE_CLOSING_GL_EXTRACT%'
     AND reqs.requested_by = usr.user_id
ORDER BY DECODE (reqs.phase_code, 'R', 1, 2),
         reqs.requested_start_date,
         usr.user_name;