Query to Find Concurrent Program Responsibilities in Oracle Apps

With the help of below query, a programmer can find concurrent program responsibilities attached to it in Oracle E-Business Suite.

Query to Find Concurrent Program Responsibilities

SELECT fcp.user_concurrent_program_name,
       frg.request_group_name,
       frtl.responsibility_name
FROM fnd_responsibility fres,
     fnd_responsibility_tl frtl,
     fnd_request_groups frg,
     fnd_request_group_units frgu,
     fnd_concurrent_programs_tl fcp
WHERE 1 = 1
  AND frtl.language = USERENV('LANG')
  AND frtl.responsibility_id = fres.responsibility_id
  AND frg.request_group_id = fres.request_group_id
  AND frgu.request_group_id = frg.request_group_id
  AND fcp.concurrent_program_id = frgu.request_unit_id
  AND fcp.language = USERENV('LANG')
  AND fcp.user_concurrent_program_name = 'PO Output for Communication'
ORDER BY 1, 2, 3, 4;

In the above query, instead of PO Output for Communication enter the concurrent program name whose responsibilities you wish to find.

Check out here >> Useful Oracle Queries

Mention the topics of queries in comments you think will be handy and available in a single page.

I hope you like the page and find it useful. We highly appreciate comments and feedback.

You can also Subscribe here to stay updated on latest posts of Oraclemine.com.

Hi I am Paras.

Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.