Query to find list of users who modified the profile options

SELECT fpot.user_profile_option_name, profile_option_value, fpov.creation_date,
fpov.last_update_date,
fpov.creation_date – fpov.last_update_date “Change Date”,
(SELECT UNIQUE user_name
FROM apps.fnd_user
WHERE user_id = fpov.created_by) “Created By”,
(SELECT user_name
FROM apps.fnd_user
WHERE user_id = fpov.last_updated_by) “Last Update By”
FROM apps.fnd_profile_options fpo,
apps.fnd_profile_option_values fpov,
apps.fnd_profile_options_tl fpot
WHERE fpo.profile_option_id = fpov.profile_option_id
AND fpo.application_id = fpov.application_id
AND start_date_active <= SYSDATE
AND NVL (end_date_active, SYSDATE) >= SYSDATE
AND fpo.profile_option_name = fpot.profile_option_name
AND level_id = 10001
AND fpot.LANGUAGE IN (SELECT language_code
FROM apps.fnd_languages
WHERE installed_flag = ‘B’
UNION
SELECT nls_language
FROM apps.fnd_languages
WHERE installed_flag = ‘B’)
ORDER BY user_profile_option_name;
  • March 7, 2019 | 19 views
  • Comments