Rem drv: <create type="views"/>
Rem $Header: paf_views.sql 01-aug-2006.22:21:29 ktamtoro Exp $
Rem
Rem paf_views.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.
Rem
Rem    NAME
Rem      paf_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    ktamtoro    08/01/06 - Backport ktamtoro_bug-5412858 from main
Rem    ktamtoro    08/01/06 - Backport ktamtoro_bug-5412858 from main
Rem    ktamtoro    07/31/06 - Create view to be exposed to public
Rem    rahgupta    08/19/05 - execid for paf_jobs
Rem    ktamtoro    08/10/05 - Move deleted check out of the view
Rem    clo         08/05/05 - fixing deleted == null check
Rem    fantic      08/03/05 - add to MGMT_PAF_JOBS: WITH CHECK OPTION
Rem    ktlaw       08/01/05 - add MGMT_PAF_JOBS
Rem    clo         07/27/05 - add check for deleted == null
Rem    ktlaw       07/27/05 - ktlaw_paf_update_0727
Rem    ktlaw       07/27/05 - Created
Rem

CREATE OR REPLACE VIEW MGMT_PAF_PROCS_LATEST
AS
   select a.* from mgmt_paf_procedures a
   where (substr(a.version,0,instr(a.version,'.')-1)+1) * 10000 +  substr(a.version,instr(a.version,'.')+1) =
   (
     select max((substr(version,0,instr(version,'.')-1)+1) * 10000 +  substr(version,instr(version,'.')+1))
     from mgmt_paf_procedures
     where base_guid = a.base_guid
   );

CREATE OR REPLACE VIEW MGMT_PAF_JOBS
AS
  select
    STATE_GUID ,INSTANCE_GUID , STEP_GUID , PARENT_STATE_GUID , STATUS ,
    REASON_CODE , LAST_UPDATED , JOB_ID , EXEC_ID, JOB_STATUS
  from MGMT_PAF_STATES
  where STATE_TYPE = 6
WITH CHECK OPTION;

CREATE OR REPLACE VIEW MGMT_PAF$PROCEDURES
AS
  select * from MGMT_PAF_PROCEDURES
  ;

CREATE OR REPLACE VIEW MGMT_PAF$INSTANCES
AS
  select * from MGMT_PAF_INSTANCES
  ;

CREATE OR REPLACE VIEW MGMT_PAF$STATES
AS
  select * from MGMT_PAF_STATES
  ;

CREATE OR REPLACE VIEW MGMT_PAF$APPLICATIONS
AS
  select * from MGMT_PAF_APPLICATIONS
  ;