--  Description: Ermittlung der Attribute einer IR
--    27.08.2008 A.Becker umgestellt auf join
--     9.12.2008 J.Fes IrDescription ergaenzt 10.8.2010 Klammern angep
--    19.12.2011 J.Fes ItemRevType ergaentzt
--    19.08.2013 J.Fes !!!! nicht mehr verwenden ist ersetzt durch Obj_Attr.SQL  !!!!

SELECT
  paoIr.pcreation_date     AS IrCreateDate,
  paoIr.plast_mod_date     AS IrLastModDate,
  puIrOwningUser.puser_id  AS IrOwningUser,
  puIrLastModUser.puser_id AS IrLastModUser,
  pgIr.pname               AS IrOwningGroup,
  pgIr.puid                AS IrOwningGroupPuid,
  s.pname                  AS IrOwningSite,
  s.psite_id               AS OwningSite_TC_pSite_ID,
  wso.pobject_desc         AS IrDescription,
  wso.pobject_name         AS IrName2,
  wso.pobject_type         AS IrType
FROM
  infodba.PPOM_APPLICATION_OBJECT paoIr
  INNER JOIN infodba.PPOM_USER puIrOwningUser ON (paoIr.rowning_useru = puIrOwningUser.puid)
  INNER JOIN infodba.PPOM_USER puIrLastModUser ON (paoIr.rlast_mod_useru = puIrLastModUser.puid)
  INNER JOIN infodba.PPOM_GROUP pgIr ON (paoIr.rowning_groupu = pgIr.puid)
  INNER JOIN infodba.PPOM_OBJECT o ON (paoIr.puid = o.puid)
  INNER JOIN infodba.PWORKSPACEOBJECT wso ON (paoIr.puid = wso.puid)
  LEFT JOIN infodba.PPOM_IMC s ON (o.rowning_siteu = s.puid)
where
  paoIr.puid = :para_puid
