Created
January 24, 2011 02:07
-
-
Save jpiwowar-zz/792692 to your computer and use it in GitHub Desktop.
Find the most recent changes to E-Business Suite profile options
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- last_profile_changes.sql | |
-- Author: John Piwowar | |
-- Purpose: Lists EBS profile options, in descending order of date set | |
-- Notes: Prompts for number of items to display | |
-- May need additional tweaking for multi-language installations | |
-- You'll probably want to change linesize and column widths to | |
-- something a more sane. | |
set pagesize 9999 | |
set linesize 80 | |
set verify off | |
col "Profile Option" for a15 | |
col "Option Level" for a13 | |
col "Value" for a15 | |
col "Set On" for a9 | |
col "Scoldee" for a15 | |
select * from | |
( | |
select tl.user_profile_option_name "Profile Option", | |
decode(val.level_id, | |
10001, 'Site', | |
10002, 'Application', | |
10003, 'Responsibility', | |
10004, 'User', | |
10005, 'Server', | |
10006, 'Organization', | |
10007, 'Server+Resp', | |
'No idea, boss') "Option Level", | |
val.profile_option_value "Value", | |
val.last_update_date "Set on", | |
usr.user_name "Scoldee" | |
from fnd_profile_options opt, | |
fnd_profile_option_values val, | |
fnd_profile_options_tl tl, | |
fnd_user usr | |
where opt.profile_option_id = val.profile_option_id | |
and opt.profile_option_name = tl.profile_option_name | |
and usr.user_id = val.last_updated_by | |
order by val.last_update_date desc | |
) | |
where rownum <= &number_of_items | |
; | |
exit; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment