Search 800 + 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"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment