Query to display long running concurrent requests.

SET LINESIZE 200;

SET PAGES 9999;

SET HEAD ON;

--

SET HEAD OFF;

ACCEPT enddt  PROMPT 'ENTER the date (ex: 01-AUG-99) > ';

PROMPT;

SET HEAD ON;

--

Instance Migration Scripts - Concurrent programs

--  Verify Concurrent Programs

  SELECT *

    FROM apps.fnd_concurrent_programs_vl

   WHERE user_concurrent_program_name = 'XYZ Price Utility Report'

ORDER BY user_concurrent_program_name;

--  Verify Concurrent Program is assigned  request set or not

SELECT fcpt.user_concurrent_program_name, fcpt.concurrent_program_id,

       frg.request_group_name

  FROM apps.fnd_concurrent_programs_tl fcpt,

       apps.fnd_request_group_units frgu,

       apps.fnd_request_groups frg

 WHERE frgu.request_unit_type = 'P'

   AND frgu.request_unit_id = fcpt.concurrent_program_id

   AND frgu.request_group_id = frg.request_group_id

   AND fcpt.user_concurrent_program_name LIKE 'abc%';