Subversion Repositories DevTools

Rev

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

Rev 13 Rev 23
Line 16... Line 16...
16 
		 WHERE osc.OS_ID = :OS_ID
 16 
		 WHERE osc.OS_ID = :OS_ID
17 
	   ) osc
 17 
	   ) osc
18 
 WHERE rc.RTAG_ID = :RTAG_ID_FK
 18 
 WHERE rc.RTAG_ID = :RTAG_ID_FK
19 
   AND pv.PKG_ID = pkg.PKG_ID
 19 
   AND pv.PKG_ID = pkg.PKG_ID
20 
   AND rc.PV_ID = PV.PV_ID
 20 
   AND rc.PV_ID = PV.PV_ID
- 
 
 21 
   AND (
21 
   AND rc.BASE_VIEW_ID = :enumPRODUCTS_BASE_VIEW_ID
22 
   	   	rc.BASE_VIEW_ID = :enumPRODUCTS_BASE_VIEW_ID
- 
 
 23 
		OR
- 
 
 24 
	 	rc.BASE_VIEW_ID = :enumAUTOPRODUCTS_BASE_VIEW_ID
- 
 
 25 
 	   )
22 
   AND osc.PROD_ID (+) = rc.PV_ID
26 
   AND osc.PROD_ID (+) = rc.PV_ID
23 
 ORDER BY UPPER(pkg.PKG_NAME), UPPER(pv.PKG_VERSION)
27 
 ORDER BY UPPER(pkg.PKG_NAME), UPPER(pv.PKG_VERSION)
24 

            28