Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
23 rsolanki 1 
/* Patches List In a Given Node In Given OS */
2 
SELECT osc.*,
3 
	   pkg.pkg_name,
4 
	   pv.pkg_version,
5 
	   pd.IS_REJECTED,
6 
	   pv.IS_PATCH,
7 
	   pv.IS_OBSOLETE
8 
  FROM PACKAGES pkg,
9 
  	   PACKAGE_VERSIONS pv,
10 
	   PRODUCT_DETAILS pd,
11 
	   (
12 
		SELECT osc.seq_num, osc.prod_id, osc.product_comments, osc.change_log_flag, osc.is_node_spec
13 
		  FROM os_contents osc
14 
		 WHERE osc.os_id = :OS_ID
15 
	   ) osc,
16 
	   (
17 
	   select * from package_patches where pv_id = :PV_ID
18 
	   )pp
19 
 WHERE pd.PROD_ID (+)= pv.PV_ID
20 
   AND pv.pkg_id = pkg.pkg_id
21 
   AND osc.PROD_ID = pv.pv_id
22 
   and pv.IS_PATCH IS NOT NULL
23 
   and pp.PATCH_ID = osc.PROD_ID
24 
ORDER BY osc.SEQ_NUM