Thursday, November 17, 2011

FLEXFIELD SECURITY RULE DEFINITIONS

/* FLEXFIELD SECURITY RULE DEFINITIONS
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 

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect