Query to Find Concurrent Program Responsibilities From Which It Can be Run


Running the following query will prompt you for the concurrent program name.

SELECT DISTINCT fcpt.user_concurrent_program_name,
  fcpt.description,
  frt.responsibility_name,
  request_group_name
FROM apps.fnd_concurrent_programs_tl fcpt,
  apps.fnd_request_groups frg,
  apps.fnd_request_group_units frgu,
  apps.fnd_responsibility fr,
  apps.fnd_responsibility_tl frt
WHERE fcpt.concurrent_program_id = frgu.request_unit_id
AND frg.request_group_id         = frgu.request_group_id
AND frg.request_group_id         = fr.request_group_id
AND fr.responsibility_id         = frt.responsibility_id
AND fcpt.application_id          = frg.application_id
AND frg.application_id           = frgu.application_id
AND fr.application_id            = frt.application_id
AND fcpt.user_concurrent_program_name LIKE '%&p_conc_programe_name%';


  • April 16, 2015 | 39 views
  • Comments