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)
0 Responses to “Query to find details of User Profile (who and When updated)”
Post a Comment