Rem drv: <create type="views" pos="rac/rac_views.sql+"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/changemgr/cm_views.sql /st_emdbsa_11.2/1 2009/02/02 12:13:29 abodge Exp $
Rem
Rem cm_views.sql
Rem
Rem Copyright (c) 2005, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cm_views.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    abodge      01/14/09 - Move CM Synch to DB Control
Rem    abodge      05/13/08 - Migrate 11GC functionality
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    xshen       05/17/05 - xshen_bug-4373232
Rem    xshen       05/12/05 - Created
Rem

-- MGMT_CM$ANNOTATION is a private view used by CM functionality
-- This view groups all annotations belonging to a CM comparison object
-- and sorts within group by the timestamps the annotations were entered.
-- Query that has a clause mgmt_cm$annotation.seq = 1, for example,
-- will get the latest annotation row. 
create or replace view mgmt_cm$annotation as 
select  
 source_obj_type, 
 source_obj_guid,
 timestamp,
 annotation_type,
 user_name,
 message, 
 ROW_NUMBER() over 
(PARTITION BY source_obj_guid 
 ORDER BY timestamp desc) as seq
from 
 mgmt_annotation
where 
 source_obj_type = 4;