SELECT po.profile_option_id,po.USER_PROFILE_OPTION_NAME,usr.user_name,rspt.responsibility_name,rsp.end_date
FROM apps.fnd_profile_options_vl po, apps.fnd_profile_option_values pov,apps.fnd_user usr, apps.fnd_application app, apps.fnd_responsibility rsp,
apps.fnd_responsibility_tl rspt,
(select name,organization_id from HR_OPERATING_UNITS) org
WHERE pov.application_id = po.application_id
AND pov.profile_option_id = po.profile_option_id
AND rsp.application_id(+) = pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value
AND app.application_id(+) = pov.level_value
AND rspt.application_id(+) = pov.level_value_application_id
AND rspt.responsibility_id(+) = pov.level_value
and usr.user_id=pov.LAST_UPDATED_BY
and pov.profile_option_value=to_char(org.organization_id (+))
and po.PROFILE_OPTION_NAME='APPL_SERVER_TRUST_LEVEL'
-- and rsp.end_date is null
and language='US';
No comments:
Post a Comment