DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Friday, April 17, 2015

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%';

No comments: