To Check The Profile Options Which Are Modified

SELECT
t.user_profile_option_name,
profile_option_value,
v.creation_date,

v.last_update_date,

v.creation_date - v.last_update_date "change Status",

(
SELECT UNIQUE user_name

FROM fnd_user

WHERE user_id = v.created_by
) "Created By",

(
SELECT user_name

FROM fnd_user

WHERE user_id = v.last_updated_by
) "Last Update By"

FROM
fnd_profile_options o,

fnd_profile_option_values v,

fnd_profile_options_tl t

WHERE
o.profile_option_id = v.profile_option_id

AND o.application_id = v.application_id

AND start_date_active <= SYSDATE

AND NVL (end_date_active, SYSDATE) >= SYSDATE

AND o.profile_option_name = t.profile_option_name

AND level_id = 10001

AND t.LANGUAGE IN
(
SELECT language_code

FROM fnd_languages

WHERE installed_flag = 'B'

UNION

SELECT nls_language

FROM fnd_languages

WHERE installed_flag = 'B'
)

ORDER BY
user_profile_option_name;