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