Oracle Applications Script Profile Options

Updated : 30-July-2002
Version : 1.0

Description

Displays Oracle Applications Profile Options

Parameters

None.

SQL Source

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

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal