All Accounts SQL Query

select
code_combination_id,
cc.segment1 "Company",
cc.segment2 "Location",
cc.segment3 "Cost Center",
cc.segment4 "Account",
cc.concatenated_segments "Full Account",
fvt.description "Account Description"

from
gl_code_combinations_kfv cc,
fnd_flex_values fv,
fnd_flex_values_tl fvt,
fnd_id_flex_segments fs

where
cc.segment4=fv.flex_value
and fv.flex_value_id=fvt.flex_value_id
and fs.flex_value_set_id=fv.flex_value_set_id
and fs.id_flex_code='GL#'
and cc.enabled_flag='Y'

order by
cc.segment4