Subversion Repositories DevTools

Rev

Rev 23 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
23 rsolanki 1 
/* All Patches */
2 
SELECT DISTINCT
3 
       osc.PROD_ID,
4 
	   pkg.pkg_name,
5 
	   pv.pkg_version,
6 
	   pd.IS_REJECTED,
7 
	   pkg.pkg_id,
8 
	   pv.is_patch,
9 
	   pv.pv_id,
10 
	   os.os_name
11 
  FROM bom_contents bc,
12 
   	   operating_systems os,
13 
       os_contents osc,
14 
	   PACKAGES pkg,
15 
  	   PACKAGE_VERSIONS pv,
16 
	   PRODUCT_DETAILS pd,
17 
	   BRANCHES br,
18 
	   DM_PROJECTS prj,
19 
	   BOMS
20 
 WHERE osc.os_id = os.os_id
21 
   AND os.node_id = bc.node_id
22 
   AND prj.PROJ_NAME = :PROJ_NAME
23 
   AND br.BRANCH_NAME = :BRANCH_NAME
24 
   AND prj.PROJ_ID = br.PROJ_ID
25 
   and br.BRANCH_ID = boms.BRANCH_ID
26 
   and boms.BOM_ID = bc.BOM_ID
27 
   AND boms.BOM_VERSION = :BOM_VERSION
28 
   AND boms.BOM_LIFECYCLE = :BOM_LIFECYCLE
29 
   AND pd.PROD_ID (+) = osc.PROD_ID
30 
   AND pv.pkg_id = pkg.pkg_id
31 
   AND osc.prod_id = pv.pv_id
32 
   AND pv.IS_PATCH IS NOT NULL
33 
 ORDER BY UPPER(pkg.pkg_name), UPPER(pv.PKG_VERSION)