Tuesday, 9 August 2016

Last Concurrent Program request on reports

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

No comments:

Post a Comment