Thanks Pando, Can you modify this query

Thanks in advance,
-------------------------------------------------
select
SUBSTR(ffv.flex_value,1,4) PARENT_VALUE,
SUBSTR(ffv.description,1,25) PARENT_DESCRIPTION,
SUBSTR(ffvh.child_flex_value_low,1,4) CHILD_LOW,
SUBSTR(ffvh.child_flex_value_high,1,4) CHILD_HIGH
from
fnd_lookups fl,
fnd_flex_hierarchies ffh,
fnd_flex_value_hierarchies ffvh,
fnd_flex_values ffv,
fnd_id_flex_segments fifs
where
ffh.flex_value_set_id(+) = ffv.flex_value_set_id
and ffh.hierarchy_id(+) = ffv.structured_hierarchy_level
and ffvh.flex_value_set_id = ffv.flex_value_set_id
and ffvh.parent_flex_value = ffv.flex_value
and ffv.flex_value_set_id = fifs.flex_value_set_id
and fifs.application_id = 101
and fifs.id_flex_code = 'GL#'
and fifs.segment_name = 'LOCATION'
and fl.lookup_type = 'YES_NO'
and fl.lookup_code = ffv.enabled_flag
and SUBSTR(ffvh.child_flex_value_low,1,4) = '1000'
and SUBSTR(ffv.flex_value,1,4) like 'C___'
and ffv.enabled_flag = 'Y'
and ffv.end_date_active is null
and fifs.id_flex_num = 101
---------------------------------------------------------