Accounting Flexfield

Accounting Flexfield
select vs.FLEX_VALUE_SET_NAME, b.FLEX_VALUE,b.FLEX_VALUE_MEANING,b.DESCRIPTION
from fnd_flex_values_vl b, FND_FLEX_VALUE_SETS vs
where FLEX_VALUE in ('216200','126502') and
ENABLED_FLAG='Y'
and b.FLEX_VALUE_SET_ID= vs.FLEX_VALUE_SET_ID and vs.FLEX_VALUE_SET_NAME = 'PRG_ACC_VS'


Using Package :
Select GCC.CONCATENATED_SEGMENTS ACCOUNT, gcc.segment1, u.SHORT_CODE, u.NAME
,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART_OF_ACCOUNTS_ID,
GCC.CODE_COMBINATION_ID) DESCRIPTION
from GL_CODE_COMBINATIONS_KFV GCC, hr_operating_units u
where gcc.SEGMENT1=u.ORGANIZATION_ID






http://oracleapps88.blogspot.com/2012/04/oracle-apps-important-tables.html
http://www.techmandate.com/tag/oracle-inventory/