Run this Query
SELECT frt.responsibility_name,
frt.description
FROM fnd_executables fe,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_request_groups frg,
fnd_responsibility fr,
fnd_responsibility_tl frt
WHERE (fcpt.user_concurrent_program_name = '
OR fe.execution_file_name = 'EXECUTION_FILE_NAME'
OR fe.executable_name = 'EXECUTABLE_NAME
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND fcpt.language = USERENV ('Lang')
AND fcp.executable_id = fe.executable_id
AND fcp.enabled_flag = 'Y'
AND fcp.concurrent_program_id = frgu.request_unit_id
AND frg.request_group_id = frgu.request_group_id
AND fr.request_group_id = frg.request_group_id
AND frt.responsibility_id = fr.responsibility_id
AND frt.language = USERENV ('Lang')
ORDER BY frt.responsibility_name,
frt.description;
* Pass the Executable Name / Executable File Name / User Concurrent Program Name
No comments:
Post a Comment