SELECT 
	XMLELEMENT(NAME "row",
		XMLELEMENT(NAME "Object.objectNumber",t.inventarisnr),
		XMLELEMENT(NAME "ObjectLocation.objectLocation",t.bp_gebouw_type),
		XMLELEMENT(NAME "ObjectLocation.normalLocation",t.bp_algemeen),
		XMLELEMENT(NAME "ObjectLocation.normalLocation",t.bp_bijzonder),
		XMLELEMENT(NAME "ObjectLocation.normalLocation",t.bp_tijdelijke),
		XMLELEMENT(NAME "Object.currentOwner",t.eig_nr),
		XMLELEMENT(NAME "Object.objectType",t.id_benaming),
		XMLELEMENT(NAME "Object.briefDescription",t.id_onderwerp),
		XMLELEMENT(NAME "Object.physicalDescription",t.mb_beschrijving),
		XMLELEMENT(NAME "Object.material",t.mb_materiaal),
		XMLELEMENT(NAME "Object.dimension.hoogte",t.mb_afmeting_h),
		XMLELEMENT(NAME "Object.dimension.breedte",t.mb_afmeting_b),
		XMLELEMENT(NAME "Object.dimension.lengte",t.mb_afmeting_l),
		XMLELEMENT(NAME "Object.dimension.breedte",t.mb_afmeting_o),
		XMLELEMENT(NAME "Object.dimension.paginas",t.mb_aantal_blz),
		XMLELEMENT(NAME "Conditioncheck.condition.algemeen",t.mb_toestand),
		XMLELEMENT(NAME "Conditioncheck.condition.volledig",t.mb_toestand_volledig),
		XMLELEMENT(NAME "Conditioncheck.note",t.mb_toestand_deel),
		XMLELEMENT(NAME "Object.content",t.ico_benaming),
		XMLELEMENT(NAME "Inscription.content.text",t.ico_opschrift_wapenschild),
		XMLELEMENT(NAME "Inscription.description.wapenschild",t.a_wapenschild),
		XMLELEMENT(NAME "Inscription.content.signatuur",t.ico_signatuur_datering),
		XMLELEMENT(NAME "Inscription.content.merkteken",t.ico_merktekens),
		XMLELEMENT(NAME "ObjectProduction.place",t.ap_produktiecentrum_algemeen),
		XMLELEMENT(NAME "ObjectProduction.maker.instelling",t.ap_produktiecentrum_specifiek),
		XMLELEMENT(NAME "ObjectProduction.maker",t.ap_auteur_naam),
		XMLELEMENT(NAME "Period.beginDate",t.dat_periode_begin),
		XMLELEMENT(NAME "Period.endDate",t.dat_periode_einde),
		XMLELEMENT(NAME "Object.style",t.dat_stijl),
		XMLELEMENT(NAME "Object.accessCategory.publiek",t.erf_publiek_toegankelijk),
		XMLELEMENT(NAME "Object.accessCategory.gebruik",t.erf_gebruik),
		XMLELEMENT(NAME "naam_gebruiker",t.naam_gebruiker),
		XMLELEMENT(NAME "ConditionChecks",
		(SELECT XMLAGG(XMLELEMENT(NAME "ConditionCheck",
			XMLATTRIBUTES(n.ID as "id"),
			XMLELEMENT(NAME "ConditionCheck.date", n.mb_nazicht_datum),
			XMLELEMENT(NAME "ConditionCheck.note", n.mb_nazicht_wat)
			))
		 FROM H_nazicht n
		 WHERE n.volgnr = t.volgnr
		 )
		 ),
		XMLELEMENT(NAME "naam_gebruiker",t.naam_gebruiker),
		XMLELEMENT(NAME "ConditionChecks",
		(SELECT XMLAGG(XMLELEMENT(NAME "ConditionCheck",
			XMLATTRIBUTES(m.ID as "id"),
			XMLELEMENT(NAME "ConditionCheck.date", m.mb_nazicht_datum),
			XMLELEMENT(NAME "ConditionCheck.note", m.mb_nazicht_wat)
			))
		 FROM H_nazicht m
		 WHERE m.volgnr = t.volgnr
		 )
		 )
		)
		
FROM Fiches t