-- TCE: Get Attr Obj New:07.06.2016 L.Up:05.04.15
-- #LUp:30.01.2020/J.Fes add LastSavDate ReleasedDateWSO
SELECT
  paoObj.pcreation_date AS CreateDate,
  paoObj.plast_mod_date AS LastModDate,
  NULL                  AS LastSavDate,
  OwningUser.puser_id   AS OwningUser,
  LastModUser.puser_id  AS LastModUser,
  OwingGroup.pname      AS OwningGroup,
  OwingGroup.puid       AS OwningGroupPuid,
  -- s.pname               AS OwningSite,
  s.psite_id            AS OwningSite_TC_pSite_ID,
  wso.pobject_desc || ''  AS Description,
  wso.pobject_name || ''  AS Name2,
  wso.pobject_type      AS Type,
    -- 30.01.2020 / add
  wso.pdate_released    AS ReleasedDateWSO
FROM
  infodba.PPOM_APPLICATION_OBJECT paoObj
  INNER JOIN infodba.PPOM_USER  OwningUser ON (paoObj.rowning_useru = OwningUser.puid)
  INNER JOIN infodba.PPOM_USER  LastModUser ON (paoObj.rlast_mod_useru = LastModUser.puid)
  INNER JOIN infodba.PPOM_GROUP OwingGroup ON (paoObj.rowning_groupu = OwingGroup.puid)
  INNER JOIN infodba.PPOM_OBJECT o ON (paoObj.puid = o.puid)
  INNER JOIN infodba.PWORKSPACEOBJECT wso ON (paoObj.puid = wso.puid)
  LEFT  JOIN infodba.PPOM_IMC s ON (o.rowning_siteu = s.puid)
where
  paoObj.puid = :para_puid
