Query to get concurrent request set details for parent request set id.

Query to get concurrent request details for parent request set id.

SELECT
  fcr1.request_id ,
  fcp1.user_concurrent_program_name ,
  DECODE(fcr1.phase_code,'C','Completed',fcr1.phase_code) phase_code,
  DECODE(fcr1.status_code,'D', 'Cancelled','E', 'Error' , 'G', 'Warning', 'H',
  'On Hold' , 'T', 'Terminating', 'M', 'No Manager' , 'X', 'Terminated', 'C',
  'Normal', fcr1.status_code) status_code,
  fcr1.request_date ,
  fcr1.requested_start_date ,
  fcr1.actual_completion_date,
  fcr1.parent_request_id
FROM
  apps.fnd_concurrent_requests fcr ,
  apps.fnd_concurrent_programs_vl fcp ,
  apps.fnd_concurrent_requests fcr1 ,
  apps.fnd_concurrent_programs_vl fcp1
WHERE
  1                            = 1
AND fcp.concurrent_program_id  = fcr.concurrent_program_id
AND fcp1.concurrent_program_id = fcr1.concurrent_program_id
AND fcr1.parent_request_id     = fcr.request_id
AND fcr.parent_request_id      = 95625343
ORDER BY
  fcr1.requested_start_date DESC;

Query 2:

select request_id ,
  user_concurrent_program_name ,
 DECODE(phase_code,'C','Completed',phase_code) phase_code,
  DECODE(status_code,'D', 'Cancelled','E', 'Error' , 'G', 'Warning', 'H',
  'On Hold' , 'T', 'Terminating', 'M', 'No Manager' , 'X', 'Terminated', 'C',
  'Normal', status_code) status_code,
  request_date ,
  requested_start_date ,
  actual_completion_date,
  parent_request_id ,
  ARGUMENT_TEXT
  from apps.FND_CONC_REQ_SUMMARY_V
  where priority_REQUEST_ID=96200984
  order by request_id;