SELECT resp_tl.responsibility_name
,req_grp.request_group_name
,cp.user_concurrent_program_name
FROM fnd_request_groups req_grp
,fnd_request_group_units req_grp_unit
,fnd_responsibility resp
,fnd_responsibility_tl resp_tl
,fnd_concurrent_programs_tl cp
WHERE req_grp.request_group_id = req_grp_unit.request_group_id
AND resp.responsibility_id = resp_tl.responsibility_id
AND resp.request_group_id = req_grp_unit.request_group_id
AND resp_tl.language = USERENV('LANG')
AND cp.language = USERENV('LANG')
AND req_grp_unit.request_unit_id = cp.concurrent_program_id
AND cp.user_concurrent_program_name LIKE '%XX%'
Good information. Keep posting.
ReplyDelete