Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* User Wip */
2 
SELECT pr.PROJ_NAME ||' / '|| rt.RTAG_NAME  AS LOCATION,
3 
	   pkg.PKG_NAME,
4 
	   rel.PKG_VERSION,
5 
	   rel.PV_ID,
6 
	   rt.RTAG_ID
7 
  FROM (
8 
 
9 
  		/* Get WIP Packages */
10 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.PKG_ID, pv.PKG_VERSION
11 
		  FROM WORK_IN_PROGRESS wip,
12 
		  	   RELEASE_TAGS rt,
13 
			   PACKAGE_VERSIONS pv
14 
		 WHERE wip.RTAG_ID = rt.RTAG_ID
15 
		   AND rt.OFFICIAL != 'Y'
16 
		   AND wip.PV_ID = pv.PV_ID
17 
		   AND pv.DLOCKED != 'Y'
18 
		   AND pv.MODIFIER_ID = :USER_ID
19 
 
20 
		UNION
21 
 
22 
		/* Get WIP Patches */
23 
        SELECT pp.PATCH_ID AS PV_ID, rt.RTAG_ID, pv.PKG_ID, pv.PKG_VERSION
24 
		  FROM RELEASE_CONTENT rc,
25 
		  	   RELEASE_TAGS rt,
26 
			   PACKAGE_PATCHES pp,
27 
			   PACKAGE_VERSIONS pv
28 
		 WHERE rc.RTAG_ID = rt.RTAG_ID
29 
		   AND rt.OFFICIAL != 'Y'
30 
		   AND pp.PV_ID = rc.PV_ID
31 
		   AND pp.PATCH_ID = pv.PV_ID
32 
		   AND pv.DLOCKED != 'Y'
33 
		   AND pv.IS_OBSOLETE IS NULL
34 
		   AND pv.MODIFIER_ID = :USER_ID
35 
 
36 
 
37 
  	   ) rel,
38 
	   PACKAGES pkg,
39 
	   RELEASE_TAGS rt,
40 
	   PROJECTS pr
41 
 WHERE rel.PKG_ID = pkg.PKG_ID
42 
   AND rel.RTAG_ID = rt.RTAG_ID
43 
   AND rt.PROJ_ID = pr.PROJ_ID
44 
ORDER BY UPPER(LOCATION), UPPER(pkg.PKG_NAME)