Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Base Env Contents */
2 
SELECT bec.*,
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 bas.*
13 
		  FROM base_env_contents bas
14 
		 WHERE bas.base_env_id = :BASE_ENV_ID
15 
	   ) bec
16 
 WHERE pv.pkg_id = pkg.pkg_id
17 
   AND bec.prod_id = pv.pv_id
18 
   AND pd.PROD_ID (+)= pv.PV_ID
19 
ORDER BY bec.seq_num