-- #DOC: select PART_NR_1_ROHLING
-- #EXA 01.04.2025/ IR:063.362.688/3 PART_NR_1_ROHLING = '160056' puid='QZRx3xNfAuf0aA'
SELECT  
formTbl.PART_NR_1_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

