-- DS NamedRefsAll 02.03.2015 J.Fes
-- #LUp: 05.03.2018 J.Fes add reference
Select
 pd.puid As DataSetPuid,
 rn.pval_0 As reference,
 imv.pmachine_type        As imv_pmachine_type,
 imv.pvolume_name         As imv_pvolume_name,
 imv.punix_path_name      As imv_punix_path_name,
 imv.pwnt_path_name       As imv_pwnt_path_name,
 imv.pnode_name           As imv_pnode_name,
 imf.psd_path_name        As imf_psd_path_name,
 imf.pfile_name           As imf_pfile_name,
 imf.poriginal_file_name  As imf_poriginal_file_name,
 imf.puid                 As imf_puid,
 pao.plast_mod_date       As imf_lastmoddat
From
 infodba.PDATASET pd
 Left Join infodba.PREF_LIST rl     On (rl.puid = pd.puid)
 Left Join infodba.PREF_NAMES rn    On (rl.puid = rn.puid And rl.pseq = rn.pseq)
 Left Join infodba.PIMANFILE imf    On (imf.puid = rl.pvalu_0)
 Left Join infodba.PIMANVOLUME imv  On (imf.rvolume_tagu = imv.puid)
 Left Join infodba.PPOM_APPLICATION_OBJECT pao On (pao.puid = imf.puid)
where
 pd.puid = :para_puid
