Oracle APPS Profil Sorgusu
Merhaba,
Profil değerlerini bulmak için aşağıdaki sorguyu kullanabilirsiniz.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
SELECT fpo.profile_option_name profil_adi, fpl.user_profile_option_name profil_kullanici_adi, DECODE (fpv.level_id, 10001, 'Site', 10002, 'Uygulama Yazılımı', 10003, 'Sorumluluk', 10004, 'Kullanıcı') profil_seviyesi, DECODE (fpv.level_id, 10001, 'Site', 10002, fa.application_short_name, 10003, frt.responsibility_name, 10004, fu.user_name) seviye_degeri, profile_option_value profil_degeri FROM fnd_profile_options fpo, fnd_profile_options_tl fpl, fnd_profile_option_values fpv, fnd_responsibility_tl frt, fnd_application fa, fnd_user fu WHERE fpo.profile_option_name = fpl.profile_option_name AND fpo.profile_option_id = fpv.profile_option_id AND fpv.level_value = fu.user_id(+) AND fpv.level_value = frt.responsibility_id(+) AND fpv.level_value = fa.application_id(+) AND fpl.user_profile_option_name = 'Self Servis Tanımını Kişiselleştir' |