<p>I administrate several Oracle Apps environment, and currently check profile options in lots of environments by loading up forms in each environment, and manually checking each variable, which requires a lot of time.</p>

<p>Is there a snippet of code which will list profile options and at what level and who they are applied to?</p>

You'll want to query
```
APPLSYS.FND_PROFILE_OPTIONS
```
and
```
FND_PROFILE_OPTION_VALUES
```
. 
For a comprehensive script that you can pick up the SQL from, look here:
http://tipsnscripts.com/?p=16