-- select PART_NR_1_ROHLING
-- exa 063.435.781/1 IR -> IR PUID CKgdfJGHAuf0aA -> REF_NUMBERS-1|REF_NUMBERS-3|REF_NUMBERS-2
 select listagg(REF_Number, '|') within group (order by REF_SEQ) As REF_Numbers
 from (
SELECT  
formTbl.PVAL_0 as REF_Number
 , formTbl.PSEQ as REF_SEQ
from infodba.pitemrevision IR
 INNER JOIN infodba.PIMANRELATION    pr ON (pr.rprimary_objectu = IR.puid)
 INNER JOIN infodba.PFORM            mf ON (mf.puid = pr.rsecondary_objectu)
 INNER JOIN infodba.PZIM4_REF_NUMBERS  formTbl ON (formTbl.puid = mf.rdata_fileu) -- and formTbl.PSEQ = 0)
 where IR.puid = :para_IrPuid
 order by formTbl.PSEQ
)
