SQL Script Profile Options

Updated: 30-Jul-2002
Version: 1.0

Description

Displays Oracle Applications Profile Options

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 300

ACCEPT prof_name PROMPT 'Enter Profile Name : '

column profile_option_name form a24 heading "Profile Name"
column profile_option_value form a45 heading "Profile Value" 

spool apps_prof.lst

select profile_option_name,profile_option_value 
from fnd_profile_option_values ov, fnd_profile_options v
where ov.profile_option_id = v.profile_option_id
and UPPER(profile_option_name) like '%&prof_name%'
/

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links