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,
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