Subversion Repositories DevTools

Rev

Rev 13 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Base Env List */
2 
SELECT be.base_env_id,
3 
	   be.base_env_name,
4 
	   DECODE( osbe.OS_ID,
5 
	   		   :OS_ID, 'selected',
6 
			   NULL
7 
	   		  ) AS selected,
8 
	   bt.bos_icon
9 
  FROM BASE_ENV be,
10 
  	   BOS_TYPES bt,
11 
	   OS_BASE_ENV osbe
12 
 WHERE be.BOS_ID = bt.BOS_ID
13 
   AND be.BOM_ID = :BOM_ID
14 
   AND osbe.BASE_ENV_ID (+) = be.BASE_ENV_ID
15 
   AND osbe.OS_ID (+) = :OS_ID
16 
ORDER BY UPPER(be.BASE_ENV_NAME)
17