Friday, November 2, 2018

Currently running concurrent program details along with user and responsibility

Currently running concurrent program details along with user and responsibility

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'
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.requested_by          = fu.user_id
AND FCR.RESPONSIBILITY_ID     = FR.RESPONSIBILITY_ID
;

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...