Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT rt.rtag_id, vw.WORLD_ID, pv.*
2 
  FROM VTREES_WORLD vw,
3 
  	   RELEASE_TAGS rt,
4 
	   VTREES vt,
5 
	   RELEASE_CONTENT rc,
6 
	   PACKAGE_VERSIONS pv,
7 
	   PACKAGE_VERSIONS opv
8 
 WHERE vw.VTREE_ID = rt.VTREE_ID
9 
   AND rt.vtree_id = vt.vtree_id
10 
   AND rc.rtag_id = rt.rtag_id
11 
   AND rc.pv_id = pv.pv_id
12 
   AND vt.HIDE = 'N'
13 
   AND rt.OFFICIAL = 'N'
14 
   AND rt.RTAG_ID <> :RTAG_ID
15 
   AND opv.pv_id = :PV_ID
16 
   AND opv.pkg_id = pv.pkg_id
17 
   AND NVL(opv.v_ext, '|LINK_A_NULL|') = NVL(pv.v_ext, '|LINK_A_NULL|')
18 
   AND vw.WORLD_ID IN (
19 
   	   			   	    /* Select My Worlds */
20 
				   	    SELECT vw.world_id
21 
						  FROM VTREES_WORLD vw,
22 
						  	   RELEASE_TAGS rt
23 
						 WHERE vw.VTREE_ID = rt.VTREE_ID
24 
						   AND rt.rtag_id = :RTAG_ID
25 
   	   			   	  )
26