-- select PART_NR_1_ROHLING
-- exa 01.04.2025/ IR:063.362.688/3 PART_NR_1_ROHLING = '160056' puid='QZRx3xNfAuf0aA'
-- mf.* -- pr.rsecondary_objectu -- ir.*,
SELECT  
   -- ('#R1:' || formTbl.PART_NR_1_ROHLING || ' #R2:'  || formTbl.PART_NR_2_ROHLING) AS R1R2
     formTbl.PART_NR_1_ROHLING
    , formTbl.PART_NR_2_ROHLING
    , formTbl.PART_NR_S_ROHLING AS XX
    -- - , formTbl.PART_NR_HAND_PROD
    , formTbl.PART_NR_S_ROHLING
    , formTbl.PART_NR_ORTHO_INC
    , formTbl.PBAUTEIL_TEXT_2
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 = 'QZRx3xNfAuf0aA' ;
 -- :para_IrPuid
