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
From
  infodba.PDATASET pd,
  infodba.PDATASET pd1,
  infodba.PIMANRELATION pr,
  infodba.PIMANTYPE ptype,
  infodba.PWORKSPACEOBJECT wso,
  infodba.PPOM_APPLICATION_OBJECT pao,
  infodba.PDATASETTYPE pdt,
  infodba.PREVISIONANCHOR a,
  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
Where
  pr.RSECONDARY_OBJECTU   = pd.PUID
And ptype.PUID            = pr.RRELATION_TYPEU
And pd.RDATASET_TYPEU     = pdt.PUID
And wso.PUID              = pd.PUID
And pd.RREV_CHAIN_ANCHORU = a.PUID
And rev.PUID              = a.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 pao.PUID(+)           = rev.PVALU_0
And pd1.PUID              = rev.PVALU_0
And rn.PUID               = pd1.PUID
And rn.PSEQ               = rl.PSEQ
And
  (
    pr.RPRIMARY_OBJECTU = 'Q8zo7NCuAjJ1aC'
  )