FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES

/* FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES

Lists security rule assignments to responsibilities
(Tested on Vision 11.5.10.2  June 2007 )*/
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