Hi All,
A short post to get COA Account Segment related fields.
select
fvvv.value,
FVVV.DESCRIPTION,
fvvv.ENABLED_FLAG Enabled,
fvvv.START_DATE_ACTIVE Start_Date,
fvvv.END_DATE_ACTIVE End_Date,
fvvv.Sort_Order,
fvvv.SUMMARY_FLAG Summary,
fvvv.FLEX_VALUE_ATTRIBUTE1 Allow_Posting,
fvvv.FLEX_VALUE_ATTRIBUTE2 Allow_Budgeting,
gl.Meaning Account_type
from
fnd_vs_value_sets fvvs
,FND_VS_VALUES_VL fvvv
,gl_lookups gl
where
fvvs.VALUE_SET_CODE=valueset_name --pass required valueset name
and fvvs.VALUE_SET_ID=fvvv.VALUE_SET_ID
and fvvv.FLEX_VALUE_ATTRIBUTE3 =gl.lookup_code
and gl.LOOKUP_TYPE='ACCOUNT TYPE'
