SELECT fcr.CONCURRENT_PROGRAM_ID,
fcr.RESPONSIBILITY_ID,
fcpt.user_concurrent_program_name,
fcr.REQUEST_ID,
frt.responsibility_name ,
fcr.REQUESTED_START_DATE ,
fcr.ARGUMENT_TEXT,
fcr.COMPLETION_TEXT,
fu.user_name ,
fu.DESCRIPTION
FROM apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_responsibility_tl frt,
apps.fnd_user fu
where 1=1
AND fcpt.concurrent_program_id = fcr.CONCURRENT_PROGRAM_ID
AND fcpt.user_concurrent_program_name like '%ReportName%'
and frt.responsibility_id = fcr.responsibility_id
and fu.user_id=fcr.REQUESTED_BY
order by fcr.REQUESTED_START_DATE DESC
fcr.RESPONSIBILITY_ID,
fcpt.user_concurrent_program_name,
fcr.REQUEST_ID,
frt.responsibility_name ,
fcr.REQUESTED_START_DATE ,
fcr.ARGUMENT_TEXT,
fcr.COMPLETION_TEXT,
fu.user_name ,
fu.DESCRIPTION
FROM apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_responsibility_tl frt,
apps.fnd_user fu
where 1=1
AND fcpt.concurrent_program_id = fcr.CONCURRENT_PROGRAM_ID
AND fcpt.user_concurrent_program_name like '%ReportName%'
and frt.responsibility_id = fcr.responsibility_id
and fu.user_id=fcr.REQUESTED_BY
order by fcr.REQUESTED_START_DATE DESC