to get GL Account definition details

To get the GL Account definition/meaning

select ffv.enabled_flag, ffv.start_date_active,ffv.end_date_active,ffvt.*
from applsys.fnd_flex_values_tl ffvt, applsys.fnd_flex_values ffv
where 1=1
and ffvt.language = 'US'
and ffvt.flex_value_id = ffv.flex_value_id
and ffv.flex_value = '27010'
and ffv.FLEX_VALUE_SET_ID in (select FLEX_VALUE_SET_ID from applsys.fnd_flex_value_sets
where 1=1
and FLEX_VALUE_SET_NAME = 'GL:Account')


To get all the child accounts related to a parent account


select ffvh.flex_value_set_id,ffvh.child_flex_value_low,ffvh.child_flex_value_high
from applsys.fnd_flex_value_hierarchies ffvh, applsys.fnd_flex_value_sets ffvs
where ffvs.flex_value_set_name = 'GL:Account'
and ffvh.flex_value_set_id = ffvs.flex_value_set_id
and ffvh.parent_flex_value = '40010'


To get Account details

select a.*, c.FLEX_VALUE_SET_NAME
from applsys.fnd_flex_values_tl a, applsys.fnd_flex_values b, applsys.fnd_flex_value_sets c
where 1=1
and a.flex_value_id =  b.flex_value_id
and b.flex_value = '40015'
and b.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID
and a.language = 'US'