Filling in hierarchy fields

Managed to work it out using a bit of SQL at source.

Posting here in case it helps anyone else:

select
eo.mch_code code,
eo.operational_status code_operational_status,

eo1.mch_code room,
eo1.operational_status room_operational_status,

eo2.mch_code building,
eo2.operational_status building_operational_status,

eo3.mch_code barracks,
eo3.operational_status barracks_operational_status,

eo4.mch_code grpbar,
eo4.operational_status grpbar_operational_status,

eo5.mch_code site,
eo5.operational_status site_operational_status from equipment_object eo

join equipment_object eo1 on eo.SUP_MCH_CODE = eo1.mch_code
join equipment_object eo2 on eo1.SUP_MCH_CODE = eo2.mch_code
join equipment_object eo3 on eo2.SUP_mch_code = eo3.MCH_CODE
join equipment_object eo4 on eo3.SUP_mch_code = eo4.MCH_CODE
join equipment_object eo5 on eo4.SUP_mch_code = eo5.MCH_CODE