/* FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES
Written by Daniel North,  ORAFINAPPS Limited 2007
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