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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s