/* DS.FS 04.03.2014 J.Fes */
Select 
 pd.puid As DataSetPuid,
 imv.pvolume_name      As imv_pvolume_name,
 imf.pfile_name        As imf_pfile_name 
--  imv.pmachine_type     As imv_pmachine_type,
--  imv.punix_path_name   As imv_punix_path_name,
--  imv.pwnt_path_name    As imv_pwnt_path_name,
--  imf.psd_path_name     As imf_psd_path_name,
From
 infodba.PDATASET pd, 
 infodba.PREF_TYPES,
 infodba.PREF_NAMES_0
 Inner Join infodba.PREF_LIST_0 rl   On (rl.puid = pd.puid)
 Left Join  infodba.PIMANFILE imf    On (imf.puid = rl.pvalu_0)
 Left Join  infodba.PIMANVOLUME imv  On (imf.rvolume_tagu = imv.puid) 
where
 pd.puid in ('A4eNR19_TzDfjB','hcTNBtqRTzDfjB') ; --= :para_puid 
  
 -- A4eNR19_TzDfjB
 -- hcTNBtqRTzDfjB 

 -- pdt.pdatasettype_name IN ('UGMASTER','UGPART','UGALTREP','UGMANIFESTATION','UGSCENARIO','NXSIMULATION','CAEGEOM','CAEMesh','CAESolution','IdeasPart','IdeasAssembly','IdeasDrawing','ProPrt','ProAsm','ProDrw')  
