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 |
|