-- Finden PFM-Master (Item) ausgehend von einem PFM-Member (Item)
-- Parameter: :para_PFMMemberItemPuid  'REDlidw4Ve1piD' -- PFMMaster                        QZFlidw4Ve1piD 
-- PCONTENTS -- PCONTENTS_0
select
	i.pitem_id As ItemName --
from
	infodba.PITEM i,
	infodba.PIMANRELATION r,
	infodba.PFOLDER f,
	infodba.PWORKSPACEOBJECT wso,
	infodba.PCONTENTS c
where
	    c.pvalu_0            = :para_PFMMemberItemPuid
	and wso.puid             = f.puid
	and c.puid               = f.puid
	and wso.pobject_name     = 'Family Members'
	and r.rsecondary_objectu = f.puid
	and i.puid               = r.rprimary_objectu
  
