con

Few important queries for the concurrent programs

. To check responsibility which contact given function

1. To get form Id from database
SELECT FUNCTION_ID, USER_FUNCTION_NAME FROM FND_FORM_FUNCTIONS_TL
You can also use 
SELECT FUNCTION_ID, FUNCTION_NAME FROM FND_FORM_FUNCTIONS

2. Pass The obtained Function id or function name to following query
SELECT frv.responsibility_name, frv.description
FROM fnd_responsibility_vl frv, fnd_form_functions fff
WHERE fff.function_name = 'FND_FNDATDAG' ------Pass Function name Here 
--f.form_id =p_form_id
AND frv.menu_id NOT IN (
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = frv.menu_id
AND frf.rule_type = 'M')
AND frv.menu_id IN (SELECT me.menu_id
FROM fnd_menu_entries me
START WITH me.function_id = fff.function_id
CONNECT BY PRIOR me.menu_id = me.sub_menu_id)
AND fff.function_id NOT IN (
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = fff.function_id AND frf.rule_type = 'F')
• To Check The Profile Options Which Are Modified

SELECT t.user_profile_option_name, profile_option_value, v.creation_date,
v.last_update_date,
v.creation_date - v.last_update_date "change Status",
(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) "Last Update By"
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 =10121
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;