Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
CREATE  FORCE VIEW "RELEASE_MANAGER"."ENVIRONMENT_VIEW" ("ENV_AREA", "PV_ID", "RTAG_ID", "VIEW_ID", "PKG_STATE", "DEPRECATED_STATE", "INSERTOR_ID", "INSERT_STAMP") AS
2 
  SELECT 2 AS ENV_AREA,
3 
    rc.PV_ID,
4 
    rc.RTAG_ID,
5 
    rc.BASE_VIEW_ID AS VIEW_ID,
6 
    rc.PKG_STATE,
7 
 rc.DEPRECATED_STATE,
8 
    rc.INSERTOR_ID,
9 
    rc.INSERT_STAMP
10 
  FROM RELEASE_CONTENT rc
11 
UNION
12 
SELECT 0 AS ENV_AREA,
13 
    wip.PV_ID,
14 
    wip.RTAG_ID,
15 
    wip.VIEW_ID,
16 
    NULL AS PKG_STATE,
17 
 NULL AS DEPRECATED_STATE,
18 
    NULL AS INSERTOR_ID,
19 
    NULL AS INSERT_STAMP
20 
  FROM WORK_IN_PROGRESS wip
21 
UNION
22 
SELECT 1 AS ENV_AREA,
23 
    pl.PV_ID,
24 
    pl.RTAG_ID,
25 
    pl.VIEW_ID,
26 
    NULL AS PKG_STATE,
27 
 NULL AS DEPRECATED_STATE,
28 
    NULL AS INSERTOR_ID,
29 
    NULL AS INSERT_STAMP
30 
  FROM PLANNED pl;