Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* Bom Base Env Combo */
SELECT be.BASE_ENV_ID,
           be.BASE_ENV_NAME,
           DECODE( :BASE_ENV_NAME,
                           be.BASE_ENV_NAME, 'selected',
                           NULL
                          ) AS SELECTED
  FROM BASE_ENV be
 WHERE be.BOM_ID = :BOM_ID  
ORDER BY UPPER(be.BASE_ENV_NAME)