| 13 |
rsolanki |
1 |
/* Bom Tree Combo */
|
|
|
2 |
SELECT bo.BOM_ID,
|
|
|
3 |
bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS BOM_VERSION,
|
|
|
4 |
DECODE( bo.BOM_ID,
|
|
|
5 |
:COMPARE_BOM_ID, 'selected',
|
|
|
6 |
NULL ) AS SELECTED
|
|
|
7 |
FROM (
|
|
|
8 |
SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
|
|
|
9 |
FROM BOMS bo
|
|
|
10 |
WHERE bo.BOM_VERSION = :BOM_VERSION
|
|
|
11 |
AND bo.BOM_NAME_ID = :BOM_NAME_ID
|
|
|
12 |
AND bo.BRANCH_ID = :BRANCH_ID
|
|
|
13 |
UNION
|
|
|
14 |
SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
|
|
|
15 |
FROM BOMS bo
|
|
|
16 |
WHERE bo.BOM_VERSION LIKE :LIKE_BOM_VERSION
|
|
|
17 |
AND bo.BOM_NAME_ID = :BOM_NAME_ID
|
|
|
18 |
AND bo.BRANCH_ID = :BRANCH_ID
|
|
|
19 |
) qry,
|
|
|
20 |
BOMS bo
|
|
|
21 |
WHERE qry.BOM_ID = bo.BOM_ID
|
| 29 |
jtweddle |
22 |
ORDER BY bo.BOM_VERSION, TO_NUMBER(bo.BOM_LIFECYCLE), qry.BOM_ID
|