WITH components AS
(
select component_id, component_alias
from component_header
start with component_id='E00028116COMP' --(A1) --substation id
connect by component_parent_id = prior component_id
)
select ch.component_alias ||'.'|| ca.attribute_name tag
from(SELECT component_id, component_alias
    FROM components
    UNION ALL
    SELECT DISTINCT ch_cables.component_id,ch_cables.component_alias
    FROM component_header ch_cables, components c
    WHERE c.component_id IN (ch_cables.component_source_id,ch_cables.component_dest_id)
) ch
inner join component_attributes ca on ch.component_id=ca.component_id
where ca.attribute_rdbms_archiving>0
order by ch.component_alias