Select Distinct
  I.PITEM_ID,
  Ir.PUID,
  Ir.PITEM_REVISION_ID,
  PrjData.PPROJECT_ID,
  PrjData.PPROJECT_NAME
FROM
           infodba.PPROJECT_LIST PRJREFL
Inner Join infodba.PITEMREVISION ir On (ir.puid = prjrefl.puid)
Inner Join infodba.PTC_PROJECT PRJDATA On (PrjRefL.PVALU_0 = PrjData.PUID )
Inner Join infodba.PITEM i On (Ir.RITEMS_TAGU = i.PUID)
Where PrjData.PPROJECT_ID Is Not Null
 and Ir.PUID = 'RweBjVm5TzDfjB'