Subversion Repositories DevTools

CREATE  FORCE VIEW "RELEASE_MANAGER"."ENVIRONMENT_VIEW" ("ENV_AREA", "PV_ID", "RTAG_ID", "VIEW_ID", "PKG_STATE", "DEPRECATED_STATE", "INSERTOR_ID", "INSERT_STAMP") AS 
  SELECT 2 AS ENV_AREA,
    rc.PV_ID,
    rc.RTAG_ID,
    rc.BASE_VIEW_ID AS VIEW_ID,
    rc.PKG_STATE,
 rc.DEPRECATED_STATE,
    rc.INSERTOR_ID,
    rc.INSERT_STAMP
  FROM RELEASE_CONTENT rc
UNION
SELECT 0 AS ENV_AREA,
    wip.PV_ID,
    wip.RTAG_ID,
    wip.VIEW_ID,
    NULL AS PKG_STATE,
 NULL AS DEPRECATED_STATE,
    NULL AS INSERTOR_ID,
    NULL AS INSERT_STAMP
  FROM WORK_IN_PROGRESS wip 
UNION 
SELECT 1 AS ENV_AREA,
    pl.PV_ID,
    pl.RTAG_ID,
    pl.VIEW_ID,
    NULL AS PKG_STATE,
 NULL AS DEPRECATED_STATE,
    NULL AS INSERTOR_ID,
    NULL AS INSERT_STAMP
  FROM PLANNED pl;