Monday, September 9, 2013
Query to find details of User Profile (who and When updated)
SET lines 160;
SET pages 1000;
SELECT t.user_profile_option_name,
profile_option_value,
v.creation_date,
v.last_update_date,
v.creation_date,
v.last_update_date "ChangeDate",
(SELECT UNIQUE user_name
FROM fnd_user
WHERE user_id = v.created_by) "Created By",
(SELECT user_name
FROM fnd_user
WHERE user_id = v.last_updated_by) "LastUpdatedBy"
FROM fnd_profile_options o,
fnd_profile_option_values v,
fnd_profile_options_tl t
WHERE o.profile_option_id = v.profile_option_id
AND o.application_id = v.application_id
AND start_date_active <=SYSDATE
AND NVL(end_date_active,SYSDATE)>=SYSDATE
AND o.profile_option_name =t.profile_option_name
AND level_id = 10001
AND t.LANGUAGE IN(SELECT language_code
FROM fnd_languages
WHERE installed_flag ='B'
UNION
SELECT nls_language
FROM fnd_languages
WHERE installed_flag ='B')
ORDER BY user_profile_option_name;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
Disclaimer
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.
0 Responses to “Query to find details of User Profile (who and When updated)”
Post a Comment