To Find USER Concurrent Request in Oracle

SELECT

  ctl.user_concurrent_program_name,

  fcr.description ,

  cp.concurrent_program_name,

  cp.enabled_flag,

  fcr.request_id,

  fcr.request_date,

  fcr.requested_by,

  fu.user_name,

  fcr.phase_code,

  fcr.status_code,

  fcr.requested_start_date,

  fcr.actual_start_date,

  fcr.actual_completion_date,

  fcr.completion_text,

  fcr.argument_text,

  fcr.request_type,

  DECODE(fcr.cancel_or_hold , 'C', 'Cancelled', 'H', 'Hold'),

  fat.application_name,

  frt.responsibility_name,

  fcr.number_of_copies,

  fcr.printer,

  fcr.print_style,

  fcr.parent_request_id,

  fcr.oracle_process_id,

  fcr.oracle_session_id,

  fcr.os_process_id,

  fcr.print_job_id,

  fcr.output_file_type

FROM

  apps.fnd_concurrent_programs_tl ctl,

  apps.fnd_concurrent_programs cp,

  apps.fnd_concurrent_requests fcr,

  apps.fnd_user fu,

  apps.FND_RESPONSIBILITY_TL frt,

  APPS.FND_APPLICATION_TL FAT

WHERE 1 = 1

AND cp.concurrent_program_id         = ctl.concurrent_program_id

AND fcr.concurrent_program_id        = ctl.concurrent_program_id

AND fcr.requested_by                 =fu.user_id

AND fcr.responsibility_id            =frt.responsibility_id

AND fcr.responsibility_application_id=frt.application_id

AND frt.application_id               =fat.application_id

and FCR.REQUEST_DATE                >=sysdate-100

  --and fu.user_name = 'USERNAME'

AND  ctl.user_concurrent_program_name = :CONC_PROGRAM_NAME

ORDER BY

  fcr.actual_start_date DESC