add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, December 21

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

No comments: