Finding responsibility using concurrent program name

EBS Table:

  1. fnd_Responsibility (Responsibility name)
  2. fnd_concurrent_programs_tl (Concurrent program name)

Query to get Responsibility using  concurrent program name


SELECT frt.responsibility_name,
frg.request_group_name,
fcpt.user_concurrent_program_name
FROM fnd_Responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV('LANG')
AND fcpt.LANGUAGE = USERENV('LANG')
AND fcpt.user_concurrent_program_name = 'Active Responsibilities and Users';

Output:

Leave a Reply

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