-- #DOC: select PART_NR_1_ROHLING
-- #EXA 063.435.781/1 IR -> IR PUID 'CKgdfJGHAuf0aA' 
SELECT formTbl.PART_NR_S_ROHLING
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.PORT_ITEMREVMASTER  formTbl ON (formTbl.puid = mf.rdata_fileu)
 where IR.puid = :para_IrPuid