Blitz Report User Access Upload

Description
Categories: Enginatics, Upload
Repository: Github
Upload to update value for profile option "Blitz Report Access" at user level.
select
null action_,
null status_,
null message_,
fpo.profile_option_name,
fpo.user_profile_option_name,
'USER' profile_level,
fu.user_name,
case 
when fpov.profile_option_value='U' then 'User'
when fpov.profile_option_value='A' then 'User Admin'
when fpov.profile_option_value='D' then 'Developer'
when fpov.profile_option_value='S' then 'System'
end profile_option_value
from
fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
fnd_user fu,
fnd_application_vl fav
where
1=1 and
fpov.level_id=10004 and
fpov.level_value=fu.user_id and
fav.application_id=fpo.application_id and
fpo.profile_option_id=fpov.profile_option_id and
fpo.application_id=fpov.application_id and
fpo.profile_option_name='XXEN_REPORT_ACCESS'
&not_use_first_block
&report_table_select 
&report_table_name 
&report_table_where_clause 
&success_records
&processed_run
order by 5
Parameter Name SQL text Validation
User Name
fu.user_name=:user_name
LOV