Subversion Repositories DevTools

Rev

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

Rev 119 Rev 5384
Line 45... Line 45...
45 
   AND pv.pkg_id = pkg.pkg_id
 45 
   AND pv.pkg_id = pkg.pkg_id
46 
   AND opv.pkg_id = pv.pkg_id
 46 
   AND opv.pkg_id = pv.pkg_id
47 
   AND NVL(opv.v_ext, '|LINK_A_NULL|') = NVL(pv.v_ext, '|LINK_A_NULL|')
 47 
   AND NVL(opv.v_ext, '|LINK_A_NULL|') = NVL(pv.v_ext, '|LINK_A_NULL|')
48 
   AND myw.world_id (+) = rel.world_id
 48 
   AND myw.world_id (+) = rel.world_id
49 
   /*------- OFFICIAL FILTER ----- */
 49 
   /*------- OFFICIAL FILTER ----- */
- 
 
 50 
 
- 
 
 51 
++ The following two lines are no longer correct
- 
 
 52 
++ This FILE does NOT appear TO be used - so it doesn't matter
- 
 
 53 
 
50 
   AND (    ( rt.OFFICIAL = 'N' AND :OFFICIAL_FILTER = 0 )	   -- Show Unofficials
54 
   AND (    ( rt.OFFICIAL = 'N' AND :OFFICIAL_FILTER = 0 )	   -- Show Unofficials
51 
         OR ( rt.OFFICIAL = 'Y' AND :OFFICIAL_FILTER = 1 )	   -- Show Officials
 55 
         OR ( rt.OFFICIAL = 'Y' AND :OFFICIAL_FILTER = 1 )	   -- Show Officials
52 
  	     OR ( :OFFICIAL_FILTER = -1 ) 				   	 	   -- Show All
 56 
  	     OR ( :OFFICIAL_FILTER = -1 ) 				   	 	   -- Show All
53 
	   )
 57 
	   )
54 
   /*------------------------------*/
 58 
   /*------------------------------*/