Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Base Env Combo */
2 
SELECT be.BASE_ENV_ID,
3 
	   be.BASE_ENV_NAME,
4 
	   DECODE( :BASE_ENV_NAME,
5 
	   		   be.BASE_ENV_NAME, 'selected',
6 
			   NULL
7 
	   		  ) AS SELECTED
8 
  FROM BASE_ENV be
9 
 WHERE be.BOM_ID = :BOM_ID
10 
ORDER BY UPPER(be.BASE_ENV_NAME)
11