Query to fetch COA Account Fields

 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'