Flexfield Security Rule Definitions

GL : Flexfield Security Rule Definitions:-

The following query will lists security rule definitions and GL account ranges.

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

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