FND-PROFILEOPTION-VALUE-SELECT QUERRY

 set lines 400;

 set pages 4000;

 col profile_option_value format a25

 col user_profile_option_name format a25

col Level format a14

 select user_profile_option_name,

  2  decode(level_id,10001,'Site',

  3  10002,'Application',

  4  10003,'Responsibility',

  5  10004,'User',

  6  10005,'Server',

  7  10006,'Organization',

  8  10007, 'ServResp',

  9  level_id) "Level",

 10  profile_option_value,

 11  level_value

 12  from

 13  fnd_profile_option_values,

 14  fnd_profile_options_vl

 15  where

 16  upper(user_profile_option_name) like upper('%ICX%%SESS%%TIME%')

 17  AND

 18  fnd_profile_option_values.profile_option_id =

 19  fnd_profile_options_vl.profile_option_id;

USER_PROFILE_OPTION_NAME  Level          PROFILE_OPTION_VALUE      LEVEL_VALUE

------------------------- -------------- ------------------------- -----------

ICX:Session Timeout       Site           30                                  0

SQL>