Query to Get Profile value at any level
SELECT
distinct pot.user_profile_option_name Profile,
DECODE (
a.profile_option_value, '1', '1 (may be "Yes")',
'2', '2 (may be "No")', a.profile_option_value
) Value,
DECODE (
a.level_id, 10001, 'Site', 10002, 'Application',
10003, 'Responsibility', 10004, 'User',
'????'
) Level_identifier,
DECODE (
a.level_id, 10002, e.application_name,
10003, c.responsibility_name, 10004,
d.user_name, '-'
) Level_Name
FROM
applsys.fnd_application_tl e,
applsys.fnd_user d,
applsys.fnd_responsibility_tl c,
applsys.fnd_profile_option_values a,
applsys.fnd_profile_options b,
applsys.fnd_profile_options_tl pot
WHERE
1 = 1
AND UPPER (pot.user_profile_option_name) LIKE UPPER ('%&v_profile%')
AND pot.profile_option_name = b.profile_option_name
AND pot.language = userenv('lang')
AND b.application_id = a.application_id(+)
AND b.profile_option_id = a.profile_option_id(+)
AND a.level_value = c.responsibility_id(+)
AND a.level_value = d.user_id(+)
AND a.level_value = e.application_id(+)
AND e.language(+) = userenv('lang')
AND (
UPPER (e.application_name) LIKE UPPER ('%&appname_respname_username%')
OR UPPER (c.responsibility_name) LIKE UPPER (
'%&&appname_respname_username%'
)
OR UPPER (d.user_name) LIKE UPPER (
'%&&appname_respname_username%'
)
)
ORDER BY
Profile,
Level_identifier,
Level_name,
Value
As a business student, you have the opportunity to explore various topics related to the business world. Writing a thesis can be an excellent way to explore a particular subject in-depth and gain invaluable experience. With the right topic, you can create a thesis that not only informs the reader but also provides a unique perspective on the subject. To help you get started, we've compiled a list of business bachelor thesis topics for students.
ReplyDeleteExcellent write-up. Extracting profile values at any level is a critical capability when working with scalable systems and user-based personalization. This concept recently proved essential during a data integration project involving one of the top pos systems canada businesses use to optimize customer experience. The clarity of your explanation helps bridge the gap between theory and real-world application much appreciated.
ReplyDeleteKeep up the HeelNews excellent work you're doing here! The quality of news reporting combined with user-friendly presentation creates a perfect platform for anyone wanting to stay informed about world matters.
ReplyDeleteKeep up the GeldNews excellent work you're doing here! The quality of financial reporting combined with user-friendly presentation creates a perfect platform for anyone wanting to stay informed about economic matters.
ReplyDeleteThis platform has become NewsThem my go-to source for reliable updates. The articles are professionally written, timely, and provide valuable perspectives that help me better understand current events.
ReplyDeleteRemarkable tool, Appium Inspector allows developers and testers to inspect app elements interactively, generate precise locators quickly, and automate tests smoothly, enhancing workflow efficiency, reducing manual effort, and ensuring reliable mobile applications for Android and iOS users.
ReplyDelete