Select
  pd.PUID               As DataSetPuid,
  wso.POBJECT_NAME      As DataSetName,
  wso.POBJECT_DESC      As DataSetDescription,
  pdt.PDATASETTYPE_NAME As DataSetType,
  ptype.PTYPE_NAME      As DataSetPTYPE_NAME,
  pu_Owni_ds.PUSER_ID   As DataSetOwningUser,
  pg_Owni_ds.PNAME      As DataSetOwningGroup,
  pao.PCREATION_DATE    As DataSetCreateDate,
  pu_lMod_ds.PUSER_ID   As DataSetLastModUser,
  pao.PLAST_MOD_DATE    As DataSetLastModDate,
  imv.PVOLUME_NAME      As imv_pvolume_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,
  imf.PFILE_NAME        As imf_pfile_name,
  rn.PVAL_0,
  imf.PORIGINAL_FILE_NAME
From
  infodba.PDATASET pd,
  infodba.PIMANRELATION pr,
  infodba.PIMANTYPE ptype,
  infodba.PWORKSPACEOBJECT wso,
  infodba.PPOM_APPLICATION_OBJECT pao,
  infodba.PDATASETTYPE pdt,
  infodba.PPOM_USER pu_Owni_ds,
  infodba.PPOM_USER pu_lMod_ds,
  infodba.PPOM_GROUP pg_Owni_ds,
  infodba.PREVISIONS_0 rev,
  infodba.PREF_NAMES_0 rn,
  infodba.PREF_LIST_0 rl,
  infodba.PIMANFILE imf,
  infodba.PIMANVOLUME imv
Where
  pr.RSECONDARY_OBJECTU   = pd.PUID
And ptype.PUID            = pr.RRELATION_TYPEU
And pd.RDATASET_TYPEU     = pdt.PUID
And wso.PUID              = pd.PUID
And pu_Owni_ds.PUID       = pao.ROWNING_USERU
And pu_lMod_ds.PUID       = pao.RLAST_MOD_USERU
And pg_Owni_ds.PUID       = pao.ROWNING_GROUPU
And rl.PUID               = pd.PUID
And rl.PUID               = rn.PUID
And imf.PUID              = rl.PVALU_0
And imv.PUID              = imf.RVOLUME_TAGU
And pao.PUID(+)           = rev.PVALU_0
And pd.RREV_CHAIN_ANCHORU = rev.PUID
And
  (
    pr.RPRIMARY_OBJECTU = 'Q9DZ3vSawX1hPA'
  -- And rev.PSEQ          = 0
  )