Request to check duplicate

SELECT fcr.request_id

       ,fcr.root_request_id "Schedule Request ID"

       ,fu.user_name "Submitted By"

       ,fct.user_concurrent_program_name

       ,fcr.argument_text

       ,fcr.RESUBMIT_INTERVAL

       ,fcr.RESUBMIT_INTERVAL_UNIT_CODE

FROM apps.fnd_concurrent_requests fcr

     ,apps.FND_concurrent_programs_tl fct

     ,apps.fnd_user fu

WHERE fcr.concurrent_program_id = fct.concurrent_program_id

and fcr.phase_code    <>'C'

and fcr.requested_by = fu.user_id

AND fcr.root_request_id IN

  (SELECT root_request_id

  FROM apps.fnd_concurrent_requests

  WHERE phase_code    <>'C'

  AND root_request_id IS NOT NULL

  GROUP BY root_request_id

  HAVING COUNT(*)> 1

  )

  order by fcr.root_request_id asc;