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.

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.