Subversion Repositories DevTools

Rev

Rev 5506 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
6080 dpurdie 1 
-- Used by Packages in this release
2 
--      :RTAG_ID
3 
--      :PKG_ID
4 
--      :V_EXT
5 
WITH ENVIRONMENT_VIEW as (
6 
-- Select information from RELEASE_CONTENT, WORK_IN_PROGRESS and PLANNED Tables
7 
--      Do not use the ENVIRONMENT_VIEW from the RM schema as it is now very slow
8 
--      This Select is faster simply because we can select on RTAG_ID
9 
      SELECT 2 AS ENV_AREA,
10 
        rc.PV_ID,
11 
        rc.RTAG_ID,
12 
        rc.BASE_VIEW_ID AS VIEW_ID,
13 
        rc.PKG_STATE,
14 
        rc.DEPRECATED_STATE,
15 
        rc.INSERTOR_ID,
16 
        rc.INSERT_STAMP,
17 
        ' ' AS OPERATION
18 
      FROM RELEASE_CONTENT rc
19 
      WHERE rc.RTAG_ID = :RTAG_ID
20 
    UNION
21 
    SELECT 0 AS ENV_AREA,
22 
        wip.PV_ID,
23 
        wip.RTAG_ID,
24 
        wip.VIEW_ID,
25 
        NULL AS PKG_STATE,
26 
        NULL AS DEPRECATED_STATE,
27 
        NULL AS INSERTOR_ID,
28 
        NULL AS INSERT_STAMP,
29 
        ' ' AS OPERATION
30 
      FROM WORK_IN_PROGRESS wip
31 
      WHERE wip.RTAG_ID = :RTAG_ID
32 
    UNION
33 
    SELECT 1 AS ENV_AREA,
34 
        pl.PV_ID,
35 
        pl.RTAG_ID,
36 
        pl.VIEW_ID,
37 
        NULL AS PKG_STATE,
38 
        NULL AS DEPRECATED_STATE,
39 
        NULL AS INSERTOR_ID,
40 
        NULL AS INSERT_STAMP,
41 
        pl.operation
42 
    FROM PLANNED pl
43 
    WHERE pl.RTAG_ID = :RTAG_ID
44 
)
119 ghuddy 45 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
6080 dpurdie 46 
       pv.PV_ID,
47 
       pkg.PKG_NAME,
119 ghuddy 48 
       pv.PKG_VERSION,
6080 dpurdie 49 
       pv.DLOCKED,
50 
       pv.BUILD_TYPE,
51 
       igw.PV_ID AS IGNORE_WARN,
52 
       igw.IS_PATCH_IGNORE,
53 
       dpv.PV_ID AS DPV_ID,
54 
       dpkg.PKG_NAME AS DPKG_NAME,
55 
       dpv.PKG_VERSION AS DPKG_VERSION,
56 
       ev.ENV_AREA,
57 
       vi.VIEW_NAME,
58 
       usr.FULL_NAME,
59 
       usr.USER_EMAIL,
60 
       pv.MODIFIED_STAMP
119 ghuddy 61 
  FROM ENVIRONMENT_VIEW ev,
6080 dpurdie 62 
       PACKAGE_DEPENDENCIES dep,
63 
       PACKAGE_VERSIONS dpv,
64 
       PACKAGE_VERSIONS pv,
65 
       PACKAGES pkg,
66 
       PACKAGES dpkg,
67 
       USERS usr,
68 
       VIEWS vi,
69 
       (
70 
 
71 
         SELECT iw.PV_ID, iw.DPV_ID, iw.IS_PATCH_IGNORE
72 
           FROM IGNORE_WARNINGS iw
73 
          WHERE iw.RTAG_ID = :RTAG_ID
74 
 
75 
       ) igw
119 ghuddy 76 
 WHERE ev.RTAG_ID = :RTAG_ID
77 
   AND ev.PV_ID = dep.PV_ID
78 
   AND dep.DPV_ID = dpv.PV_ID
79 
   AND dpv.PKG_ID = :PKG_ID
80 
   AND NVL( dpv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
81 
   AND dep.PV_ID = pv.PV_ID
82 
   AND pv.PKG_ID = pkg.PKG_ID
83 
   AND dpv.PKG_ID = dpkg.PKG_ID
84 
   AND ev.VIEW_ID = vi.VIEW_ID
85 
   AND pv.MODIFIER_ID = usr.USER_ID
86 
   AND igw.PV_ID (+) = dep.PV_ID
87 
   AND igw.DPV_ID (+) = dep.DPV_ID
88 
 ORDER BY UPPER(pkg.PKG_NAME)
89