Oracle Applications

Query to check recently updated profile options

SET LINES 400 PAGES 400
col PROFILE_OPTION_NAME for a50
col PROFILE_OPTION_VALUE for a50

select a.PROFILE_OPTION_NAME,b.profile_option_value,to_char(b.last_update_date,'DD-MON-YYYY HH24:MM'),b.LAST_UPDATED_BY,b.level_id 
from apps.fnd_profile_options a, apps.fnd_profile_option_values b 
where a.profile_option_id=b.profile_option_id 
and b.last_update_date > sysdate - 10;

Above query show you profile options updated in last 10 days.

========================================================================