SELECT frt.responsibility_name, frg.request_group_name,
frsv.user_request_set_name
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_request_sets_vl frsv
WHERE fr.request_group_id = frg.request_group_id
AND fr.responsibility_id = frt.responsibility_id
AND frg.request_group_id = frgu.request_group_id
AND frgu.request_unit_id = frsv.request_set_id
AND frt.language = USERENV('LANG')
AND frsv.user_request_set_name LIKE '<<Request Set Name>>'
frsv.user_request_set_name
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_request_sets_vl frsv
WHERE fr.request_group_id = frg.request_group_id
AND fr.responsibility_id = frt.responsibility_id
AND frg.request_group_id = frgu.request_group_id
AND frgu.request_unit_id = frsv.request_set_id
AND frt.language = USERENV('LANG')
AND frsv.user_request_set_name LIKE '<<Request Set Name>>'
No comments:
Post a Comment