How to Verify Debug Logging Levels Set for a User.sql

SELECT
	level_name
  , per.username
  , profile_option_name
  , DECODE(profile_option_value
			 ,'1000','Severe'
			 ,'1100','Incident'
			 ,'300','Finest'
			 ,'400','Finer'
			 ,'500','Fine'
			 ,'700','Config'
			 ,'800','Info'
			 ,'900','Warning'
			 , profile_option_value) profile_option_value
  , val.last_update_date             val_last_update_date
FROM
	fusion.fnd_profile_options_B     opt
  , fusion.fnd_profile_option_values val
  , fusion.per_users                 per
WHERE
	opt.profile_option_id          = val.profile_option_id
	AND per.user_guid (+)          = val.level_value
	AND opt.PROFILE_OPTION_NAME LIKE ('AFLOG%') --('AFLOG_ENABLED','AFLOG_EXTENDED_ENABLED','AFLOG_LEVEL','AFLOG_MODULE','AFLOG_PLSQL_FILENAME','AFLOG_QUICKTRACE_ENABLED','AFLOG_QUICKTRACE_LEVEL')
ORDER BY
	level_name
  , username
  , profile_option_name