Query to get Chart Of Account Structure Name and Segments in Oracle fusion

select
  b.FORM_LEFT_PROMPT "Chart Of Account Segment Name",
  b.description,
  a.segment_name "CCA_VALUSET",
  c.ID_FLEX_STRUCTURE_NAME "Chart Of Account Structure Name",
  b.application_column_name "Internal Segment"
from
  FND_ID_FLEX_SEGMENTS a,
  FND_ID_FLEX_SEGMENTS_TL b,
  FND_ID_FLEX_STRUCTURES_VL c
where
  b.language = 'US'
  and c.ID_FLEX_NUM = b.ID_FLEX_NUM
  and c.enabled_flag = 'Y'
  and b.application_id = a.application_id
  and b.id_flex_num = a.id_flex_num
  and b.application_column_name = a.application_column_name
  and a.application_id = 101