List Of Responsibilities to which a concurrent program is Attached

This simple query can help you to identify the list of responsibilities to which a concurrent program is attached.

SELECT DISTINCT responsibility_name
FROM apps.fnd_responsibility_vl frv,
apps.fnd_request_group_units frg,
apps.fnd_concurrent_programs_tl fcp
WHERE frv.request_group_id = frg.request_group_id
AND frg.request_unit_id = fcp.concurrent_program_id
AND fcp.user_concurrent_program_name = ‘<Concurrent Program Name>’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s