Subversion Repositories DevTools

Rev

Rev 5506 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 6080
Line 1... Line 1...
1 
/* User by Packages in this release */
 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 
)
2 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
 45 
SELECT DECODE( ev.PKG_STATE, NULL, 0, ev.PKG_STATE ) AS PKG_STATE,
3 
	   pv.PV_ID,
 46 
       pv.PV_ID,
4 
	   pkg.PKG_NAME,
 47 
       pkg.PKG_NAME,
5 
       pv.PKG_VERSION,
 48 
       pv.PKG_VERSION,
6 
	   pv.DLOCKED,
 49 
       pv.DLOCKED,
7 
	   pv.BUILD_TYPE,
 50 
       pv.BUILD_TYPE,
8 
	   igw.PV_ID AS IGNORE_WARN,
 51 
       igw.PV_ID AS IGNORE_WARN,
9 
	   igw.IS_PATCH_IGNORE,
 52 
       igw.IS_PATCH_IGNORE,
10 
	   dpv.PV_ID AS DPV_ID,
 53 
       dpv.PV_ID AS DPV_ID,
11 
	   dpkg.PKG_NAME AS DPKG_NAME,
 54 
       dpkg.PKG_NAME AS DPKG_NAME,
12 
	   dpv.PKG_VERSION AS DPKG_VERSION,
 55 
       dpv.PKG_VERSION AS DPKG_VERSION,
13 
	   ev.ENV_AREA,
 56 
       ev.ENV_AREA,
14 
	   vi.VIEW_NAME,
 57 
       vi.VIEW_NAME,
15 
	   usr.FULL_NAME,
 58 
       usr.FULL_NAME,
16 
	   usr.USER_EMAIL,
 59 
       usr.USER_EMAIL,
17 
	   pv.MODIFIED_STAMP
60 
       pv.MODIFIED_STAMP
18 
  FROM ENVIRONMENT_VIEW ev,
 61 
  FROM ENVIRONMENT_VIEW ev,
19 
  	   PACKAGE_DEPENDENCIES dep,
 62 
       PACKAGE_DEPENDENCIES dep,
20 
	   PACKAGE_VERSIONS dpv,
 63 
       PACKAGE_VERSIONS dpv,
21 
	   PACKAGE_VERSIONS pv,
 64 
       PACKAGE_VERSIONS pv,
22 
	   PACKAGES pkg,
 65 
       PACKAGES pkg,
23 
	   PACKAGES dpkg,
 66 
       PACKAGES dpkg,
24 
	   USERS usr,
 67 
       USERS usr,
25 
	   VIEWS vi,
 68 
       VIEWS vi,
26 
	   (
69 
       (
27
70
28 
	     SELECT iw.PV_ID, iw.DPV_ID, iw.IS_PATCH_IGNORE
 71 
         SELECT iw.PV_ID, iw.DPV_ID, iw.IS_PATCH_IGNORE
29 
	       FROM IGNORE_WARNINGS iw
72 
           FROM IGNORE_WARNINGS iw
30 
		  WHERE iw.RTAG_ID = :RTAG_ID
73 
          WHERE iw.RTAG_ID = :RTAG_ID
31
74
32 
	   ) igw
75 
       ) igw
33 
 WHERE ev.RTAG_ID = :RTAG_ID
 76 
 WHERE ev.RTAG_ID = :RTAG_ID
34 
   AND ev.PV_ID = dep.PV_ID
 77 
   AND ev.PV_ID = dep.PV_ID
35 
   AND dep.DPV_ID = dpv.PV_ID
 78 
   AND dep.DPV_ID = dpv.PV_ID
36 
   AND dpv.PKG_ID = :PKG_ID
 79 
   AND dpv.PKG_ID = :PKG_ID
37 
   AND NVL( dpv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')
 80 
   AND NVL( dpv.V_EXT, '|LINK_A_NULL|') = NVL( :V_EXT, '|LINK_A_NULL|')