Subversion Repositories DevTools

Rev

Rev 15 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15 Rev 19
Line 5... Line 5...
5 
	   obe.BASE_ENV_ID,
 5 
	   obe.BASE_ENV_ID,
6 
	   bec.PROD_ID,
 6 
	   bec.PROD_ID,
7 
	   pkg.PKG_NAME,
7 
	   pkg.PKG_NAME,
8 
	   pkg.SUNOS_ELECTRONIC_NAME,
 8 
	   pkg.SUNOS_ELECTRONIC_NAME,
9 
	   pv.PKG_VERSION,
 9 
	   pv.PKG_VERSION,
- 
 
 10 
	   pv.PATCH_ELECTRONIC_NAME,
10 
	   pv.MODIFIED_STAMP,
 11 
	   pv.MODIFIED_STAMP,
11 
	   pv.IS_PATCH,
 12 
	   pv.IS_PATCH,
12 
	   be.BOS_ID,
 13 
	   be.BOS_ID,
13 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
 14 
	   LOWER( bt.BOS_TYPE ) AS BOS_TYPE,
14 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME
 15 
	   LOWER( bt.ELECTRONIC_NAME ) AS OS_NAME
Line 31... Line 32...
31 
   AND pkg.PKG_ID = pv.PKG_ID
 32 
   AND pkg.PKG_ID = pv.PKG_ID
32 
   AND be.BASE_ENV_ID =obe.BASE_ENV_ID
 33 
   AND be.BASE_ENV_ID =obe.BASE_ENV_ID
33 
   AND bt.BOS_ID = be.BOS_ID
 34 
   AND bt.BOS_ID = be.BOS_ID
34 
   AND bt.BOS_ID IN (2)	-- Solaris only
 35 
   AND bt.BOS_ID IN (2)	-- Solaris only
35 
   AND os.NOT_XML IS NULL
36 
   AND os.NOT_XML IS NULL
- 
 
 37 
   AND bec.NOT_XML IS NULL
36
38
37 
ORDER BY bec.SEQ_NUM
39 
ORDER BY bec.SEQ_NUM
38 

            40