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