To get the request details by Request id

SELECT

user_concurrent_program_name,

responsibility_name,

request_date,

argument_text,

request_id,

phase_code,

status_code

FROM

fnd_concurrent_requests fcr,

fnd_concurrent_programs_tl fcp,

fnd_responsibility_tl fr,

fnd_user fu 

WHERE

fcr.concurrent_program_id = fcp.concurrent_program_id 

and fcr.responsibility_id = fr.responsibility_id 

and fcr.requested_by = fu.user_id

and request_id='27775711'

ORDER BY REQUEST_DATE DESC;