SELECT DISTINCT frt.responsibility_name, frg.request_group_name,fr.application_id
FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
fnd_request_groups frg
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frt.LANGUAGE = USERENV('LANG');
FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
fnd_request_groups frg
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frt.LANGUAGE = USERENV('LANG');
No comments:
Post a Comment