add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, June 21

Function Assigned to Responsibilities Query

SELECT
fff.function_name
,frv.responsibility_name
,frv.description

FROM fnd_responsibility_vl frv,
fnd_form_functions fff

WHERE 1=1
AND fff.function_name = 'PA_AF_CREATE_AGREEMENT'
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')
AND frv.responsibility_name LIKE 'NUAN US%'
;

No comments: