select fcp.concurrent_program_name
,fcp.user_concurrent_program_name
,fcp.concurrent_program_id
,fcp.enabled_flag
,fcp.srs_flag
,frgu.request_group_id
,fr.responsibility_id
,fr.responsibility_name
from fnd_concurrent_programs_vl fcp
,fnd_request_group_units frgu
,fnd_responsibility_vl fr
where fcp.concurrent_program_id = frgu.request_unit_id
and frgu.request_group_id = fr.request_group_id
and fcp.concurrent_program_name = '&name';
The flow would be as follows:
Concurrent Program -> Request Group -> Responsibility -> User
By
Vamsi
[Updated on: Thu, 08 February 2007 06:41]
Report message to a moderator