Flexfield Security Rule Assignments

GL : Flexfield Security Rule Assignments:-
------------------------------------------------

FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES

The following query will lists security rule assignments to responsibilities

I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.

SELECT A.APPLICATION_NAME
, FVR.FLEX_VALUE_RULE_NAME
, R.RESPONSIBILITY_KEY
FROM FND_FLEX_VALUE_RULES FVR,
FND_FLEX_VALUE_RULE_USAGES RU, FND_RESPONSIBILITY R, FND_APPLICATION_TL A
WHERE FVR.FLEX_VALUE_RULE_ID = RU.FLEX_VALUE_RULE_ID
AND RU.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND RU.APPLICATION_ID = A.APPLICATION_ID
AND FVR.FLEX_VALUE_RULE_NAME LIKE '%'
ORDER BY FLEX_VALUE_RULE_NAME