select fcpt.user_concurrent_program_name,
frg.request_group_name,
fr.responsibility_key
from fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_request_groups frg,
fnd_responsibility fr
where fcpt.concurrent_program_id
= frgu.request_unit_id
and frgu.request_group_id
= frg.request_group_id
and frg.request_group_id
= fr.request_group_id
and lower(fcpt.user_concurrent_program_name)
like lower(
'&program_name')
转载于:https://www.cnblogs.com/AI-xiaocai/p/11349677.html
相关资源：JAVA上百实例源码以及开源项目
