Query to find KEY FLEX FIELDS (KFF)

Query to find KEY FLEX FIELDS (KFF)

select  FIF.APPLICATION_ID  ,

        FIF.ID_FLEX_CODE    ,

        FIF.ID_FLEX_NAME    ,

        FIF.APPLICATION_TABLE_NAME ,

        FIF.DESCRIPTION     ,

        FIFS.ID_FLEX_NUM    ,

        FIFS.ID_FLEX_STRUCTURE_CODE  ,

        FIFSE.SEGMENT_NAME,

        FIFSE.SEGMENT_NUM,

        FIFSE.FLEX_VALUE_SET_ID

from    FND_ID_FLEXS FIF    ,

        FND_ID_FLEX_STRUCTURES FIFS ,

        FND_ID_FLEX_SEGMENTS FIFSE

where   FIF.APPLICATION_ID = FIFS.APPLICATION_ID

and     FIF.ID_FLEX_CODE   = FIFS.ID_FLEX_CODE

and     FIFSE.APPLICATION_ID = FIF.APPLICATION_ID

and     FIFSE.ID_FLEX_CODE = FIF.ID_FLEX_CODE

and     FIFSE.ID_FLEX_NUM = FIFS.ID_FLEX_NUM

and     FIF.ID_FLEX_CODE LIKE 'GL#'

and     FIF.ID_FLEX_NAME LIKE 'Accounting Flexfield';