Total Pageviews

Friday, July 21, 2017

Query to find the available responsibilities for given operating_unit


SELECT fr.responsibility_name
FROM fnd_responsibility_vl fr,
FND_APPLICATION_TL fat,
fnd_profile_options_vl fpo,
FND_PROFILE_OPTION_VALUES fpov
WHERE fat.application_id = fr.application_id
AND fpov.level_value = fr.responsibility_id(+)
AND fpov. profile_option_value =:p_operating_unit_id
AND fpov.profile_option_id = fpo.profile_option_id
AND fpo.user_profile_option_name like 'MO: Operating Unit';

No comments:

Post a Comment