Wednesday, 20 May 2015

SQL Query to retrive profile option value from backend

SELECT
fpot.user_profile_option_name Profile,
decode(fpov.level_id,
10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User') Profile_option_level,
decode(fpov.level_id,
10001,'Site',
10002,fa.application_short_name,
10003,frt.Responsibility_name,
10004,fu.user_name) profile_Level_Value,
nvl(fpov.profile_option_value,'Is Null') Profile_option_Value
FROM 
fnd_profile_option_values fpov,
fnd_profile_options_tl fpot ,
fnd_profile_options fpo,
fnd_responsibility_tl frt,
fnd_application fa,
fnd_user fu
WHERE
fpo.profile_option_name = fpot.profile_option_name
and  fpo.profile_option_id = fpov.profile_option_id
and  fpov.level_value = frt.responsibility_id (+)
and  fpov.level_value = fa.application_id (+)
and  fpov.level_value = fu.user_id (+)
and  fpot.user_profile_option_name like ('%FND%Debug%')
order by 1,2;

No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...