Get details of concurrent requests which are running currently and also the script will provide details of who is running the request and from which responsibility<\/p>\n
<\/code><\/p>\n","protected":false},"excerpt":{"rendered":" Get details of concurrent requests which are running currently and also the script will provide details of who is running the request and from which responsibility SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name, TO_CHAR(fcr.actual_start_date,’DD-MON-YYYY HH24:MI:SS’) actual_start_date FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.phase_code =’R’ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-4095","post","type-post","status-publish","format-standard","hentry","category-sysadmin-aol"],"yoast_head":"\n
\nSELECT fcp.user_concurrent_program_name,
\n fcr.request_id,
\n fcr.request_date,
\n fu.user_name Requested_By ,
\n fr.responsibility_name,
\n TO_CHAR(fcr.actual_start_date,'DD-MON-YYYY HH24:MI:SS') actual_start_date
\nFROM fnd_concurrent_requests fcr ,
\n fnd_concurrent_programs_tl fcp ,
\n fnd_user fu ,
\n fnd_responsibility_tl fr
\nWHERE 1 =1
\nAND fcr.phase_code ='R'
\nAND fcr.concurrent_program_id = fcp.concurrent_program_id
\nAND fcr.requested_by = fu.user_id
\nAND FCR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
\n;<\/p>\n