-- #DOC: select GUIDELINE_DRAWINGS
-- #EXA: 063.435.781/1 IR -> IR PUID CKgdfJGHAuf0aA -> GUIDELINE_DRAWINGS-1|GUIDELINE_DRAWINGS-2
select listagg(ListValue, '|') within group (order by REF_SEQ) As ListValues
 from (
SELECT
formTbl.PVAL_0 as ListValue
 , 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_GUIDELINE_DRAWINGS  formTbl ON (formTbl.puid = mf.rdata_fileu) 
 where IR.puid = :para_IrPuid
 order by formTbl.PSEQ
)
