/* Get Attr Obj New:19.08.13 L.Up:05.04.15 */
SELECT
  paoObj.pcreation_date AS CreateDate,
  paoObj.plast_mod_date AS LastModDate,
  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,
   CONVERT(wso.pobject_desc,'UTF8','WE8ISO8859P1')  AS Description,
  wso.pobject_name      AS Name2,
  wso.pobject_type      AS Type
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
