Oracle Fusion: Query to fetch Chart of Accounts Value Set Values

Hi,

Following query can be used to see the values in Manage Values page.

select

fv.value,

fv.DESCRIPTION,

fv.ENABLED_FLAG Enabled,

fv.START_DATE_ACTIVE Start_Date,

fv.END_DATE_ACTIVE End_Date,

fv.SORT_ORDER,

fv.SUMMARY_FLAG Summary,

fv.FLEX_VALUE_ATTRIBUTE1 Posting_Allowed,

fv.FLEX_VALUE_ATTRIBUTE2 Budget_Allowed,

gl.Meaning Account_type,

fv.EXTERNAL_DATA_SOURCE

from

fnd_vs_value_sets fvvs

,FND_VS_VALUES_VL fv

,gl_lookups gl

where

fvvs.VALUE_SET_ID=fv.VALUE_SET_ID

and fv.FLEX_VALUE_ATTRIBUTE3 =gl.lookup_code

and gl.LOOKUP_TYPE='ACCOUNT TYPE'

Oracle Fusion