Query to get Accounting KFF Information

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’;

Advertisements