SQL Queries for checking Profile Option Values
The following queries are useful to get the profile option values of a profile option at site, application, responsibility and user level
1) Obtain Profile Option values for Profile Option name like ‘%Ledger%’ and Responsibility name like ‘%General%Ledger%’
SELECT substr(pro1.user_profile_option_name,1,35) Profile, decode(pov.level_id, 10001,'Site', 10002,'Application', 10003,'Resp', 10004,'User') Option_Level, decode(pov.level_id, 10001,'Site', 10002,appl.application_short_name, 10003,resp.responsibility_name, 10004,u.user_name) Level_Value, nvl(pov.profile_option_value,'Is Null') Profile_option_Value FROM fnd_profile_option_values pov, fnd_responsibility_tl resp, fnd_application appl, fnd_user u, fnd_profile_options pro, fnd_profile_options_tl pro1 WHERE pro1.user_profile_option_name like ('%Ledger%') and pro.profile_option_name = pro1.profile_option_name and pro.profile_option_id = pov.profile_option_id and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */ and pov.level_value = resp.responsibility_id (+) and pov.level_value = appl.application_id (+) and pov.level_value = u.user_id (+) order by 1,2; |
2) Obtain all Profile Option values setup for a particular responsibility. Replace the responsibility name as per your requirement.
SELECT substr(pro1.user_profile_option_name,1,35) Profile, decode(pov.level_id, 10001,'Site', 10002,'Application', 10003,'Resp', 10004,'User') Option_Level, decode(pov.level_id, 10001,'Site', 10002,appl.application_short_name, 10003,resp.responsibility_name, 10004,u.user_name) Level_Value, nvl(pov.profile_option_value,'Is Null') Profile_option_Value FROM fnd_profile_option_values pov, fnd_responsibility_tl resp, fnd_application appl, fnd_user u, fnd_profile_options pro, fnd_profile_options_tl pro1 WHERE pro.profile_option_name = pro1.profile_option_name and pro.profile_option_id = pov.profile_option_id and resp.responsibility_name like '%General%Ledger%' and pov.level_value = resp.responsibility_id (+) and pov.level_value = appl.application_id (+) and pov.level_value = u.user_id (+) order by 1,2; |
1 comment:
You marveled at the islands and at the caves we visited "This one should be named astonishing Cave," you said.
It boasts great weather, long days of sunshine, majestic beaches and beautiful
natural attractions. It is hardly any paperwork involved and it is actually going to be a lot of fun for U.
She never did, although she named her daughter Santana.
Also certified professionals events have not been able to differentiate themselves
from the so far non-certified (by organizing events with a high
degree of professionalism) therefore, the relevance
of the event management courses in India is still under the
scanner. With the never-ending need for their catering services
for different functions, businesses that literally cater are now on a widespread scale.
They work to arrange everything from wedding
menu, flowers, decoration, theme development,
lighting, audio and visuals and technical requirements to reception itinerary.
Now if you want to buy the folding banquet table in your town you
can also narrow down your search by mentioning the location of yours.
People buy products from certain companies
based on the company's image. This website offers clothing and accessories for men, women and children, and they sell sun hats, swimwear, shirts, pants, skirts, and dresses. You will only be just a couple of minutes away on the bus from the Westminster Abbey, the Westminster Cathedral and the Large Ben. Veterinary Assistant - Veterinary assistants do more than learn about the anatomy and physiology of animals. Admittedly, it was a very well laid out place for a stranger to drive for the first time. The program is available in the United States for any clothes that were purchased at any Sears location, either in person, mail order, or over the Internet. She didn't even let me sob
another minute on that phone. Weddings were also an area that generally needed more marketing support.
I guess buying white shirts might be the best solution,
except for the fact that my son's white shirts don't stay white throughout
the school day. At Olbrich Gardens, you'll have your choice of beautiful places to hold a wedding. If it is not available, tell the parent that the conference is over and that you will schedule another one where the administration will be present. Well, other areas in the Southeast are for lovers too, and not just in February. We spent 3 nights and 4 days in this Beautiful Hotel and Conference Center. You can view the entire women's collection at: Edun Women.
This is the average height of women 20 through 69 years old; women 70-79 must shrink a little or else they did
not have as good nutrition: they average 5'3," while women 80 and up average a diminutive 5'1". Moreover, these quality products come in reasonable prices, thus making each item a good buy. Just one unhappy worker or one with a bad attitude at any level can do terrible things to your department's image.
Take a look at my site: konferencje rzeszów
Post a Comment