SELECT 

PDM_PRODUCTITEM.
PINAME, 
PDM_PRODUCTITEMVERSION.PIVREV, 
PDM_PRODUCTITEMVERFILE.PIVFMAPNAME, 
PDM_PRODUCTITEM.PITYPEID, 
PDM_PRODUCTITEMVERSION.RLID, 
PDM_RELEASELEVEL.RLNAME 

FROM 

PDM.PDM_PRODUCTITEM 
PDM_PRODUCTITEM, 
PDM.PDM_PRODUCTITEMVERFILE 
PDM_PRODUCTITEMVERFILE, 
PDM.PDM_PRODUCTITEMVERSION 
PDM_PRODUCTITEMVERSION, 
PDM.PDM_RELEASELEVEL 
PDM_RELEASELEVEL 

WHERE 

PDM_PRODUCTITEM.PINAME = PDM_PRODUCTITEMVERFILE.PIVFNAME 
AND PDM_PRODUCTITEMVERFILE.PIVID = PDM_PRODUCTITEMVERSION.PIVID 
AND PDM_PRODUCTITEMVERSION.RLID = PDM_RELEASELEVEL.RLID 
AND ((PDM_PRODUCTITEM.PITYPEID=141))