select level level_num,b.*
from fnd_flex_value_children_v b
where b.flex_value_set_id= 1014868
and b.parent_flex_value <>'T'
connect by prior b.parent_flex_value = b.flex_value
start with b.flex_value ='100110210';
