Search from 700 + Posts

Jan 22, 2013

Query to Check if a Profile Option Is Set In Oracle Applications


Below is query to Check if a Profile Option Is Set In Oracle Applications.

Parameter for Query is Profile Name 


 SELECT   po.user_profile_option_name, po.profile_option_name "NAME" , DECODE (TO_CHAR (pov.level_id), '10001', 'SITE' , '10002', 'APP', '10003', 'RESP', '10004', 'USER', '???') "LEV", DECODE (TO_CHAR (pov.level_id) , '10001', '', '10002', app.application_short_name , '10003', rsp.responsibility_key, '10004', usr.user_name, '???')  "CONTEXT"
                      , pov.profile_option_value "VALUE"
         FROM fnd_profile_options_vl po, fnd_profile_option_values pov
                      , fnd_user usr, fnd_application app, fnd_responsibility rsp
      WHERE (po.profile_option_name = upper('&profil_name'))
             AND pov.application_id = po.application_id AND pov.profile_option_id =   po.profile_option_id
             AND usr.user_id(+) = pov.level_value AND rsp.application_id(+) =  pov.level_value_application_id
             AND rsp.responsibility_id(+) = pov.level_value AND app.application_id(+)   = pov.level_value
ORDER BY "NAME", pov.level_id, "VALUE"

No comments:

Post a Comment