/* FLEXFIELD SECURITY RULE DEFINITIONS
Written by Daniel North,  ORAFINAPPS Limited 2007
Lists security rule definitions and GL account ranges
(Tested on Vision 11.5.10.2  June 2007 )*/
SELECT A.APPLICATION_NAME	"APPS"				,			   
FS.SEGMENT_NAME				   						,			  
FVS.FLEX_VALUE_SET_NAME						 		,
	FVR.FLEX_VALUE_RULE_NAME						,
FVR.PARENT_FLEX_VALUE_LOW	"PRNT L"				,
FVR.PARENT_FLEX_VALUE_HIGH	"PRNT H"				,
FVRL.INCLUDE_EXCLUDE_INDICATOR "INC/EXCL"			,
FVRL.FLEX_VALUE_LOW			   						,
FVRL.FLEX_VALUE_HIGH								 
FROM FND_FLEX_VALUE_RULES FVR, FND_FLEX_VALUE_SETS FVS, 
FND_FLEX_VALUE_RULE_LINES FVRL, FND_ID_FLEX_SEGMENTS FS, FND_APPLICATION_TL A
WHERE FVR.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
AND FVR.FLEX_VALUE_RULE_ID = FVRL.FLEX_VALUE_RULE_ID
AND FS.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
AND FS.APPLICATION_ID = A.APPLICATION_ID
ORDER BY A.APPLICATION_NAME	,FS.SEGMENT_NAME, FVS.FLEX_VALUE_SET_NAME,FVR.FLEX_VALUE_RULE_NAME						,
FVR.PARENT_FLEX_VALUE_LOW	,FVR.PARENT_FLEX_VALUE_HIGH	,FVRL.FLEX_VALUE_LOW, FVRL.FLEX_VALUE_HIGH