| 64 |
jtweddle |
1 |
/* Bom Tree Combo For SAN FRANCISCO*/
|
|
|
2 |
SELECT DISTINCT bo.BOM_ID,
|
|
|
3 |
bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS BOM_VERSION,
|
|
|
4 |
DECODE( bo.BOM_ID,
|
|
|
5 |
:BRANCH_ID, 'selected',
|
|
|
6 |
NULL ) AS SELECTED,
|
|
|
7 |
bn.BOM_NAME
|
|
|
8 |
FROM (
|
|
|
9 |
SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
|
|
|
10 |
FROM BOMS bo, BOM_STATE bs, PRODUCTION_BOM pm
|
|
|
11 |
WHERE bo.BRANCH_ID = :BRANCH_ID
|
|
|
12 |
AND bs.STATE_ID = pm.STATE_ID
|
|
|
13 |
AND bs.BOM_ID = bo.BOM_ID
|
|
|
14 |
) qry,
|
|
|
15 |
BOMS bo, BOM_NAMES bn, BOM_STATE bs
|
|
|
16 |
WHERE qry.BOM_ID = bo.BOM_ID
|
|
|
17 |
AND bn.BOM_NAME_ID = bo.BOM_NAME_ID
|
|
|
18 |
AND bn.BOM_NAME = :BOM_NAME
|
|
|
19 |
AND bs.BOM_ID = bo.BOM_ID
|
|
|
20 |
AND bs.IS_DISPLAYED = 'Y'
|
|
|
21 |
AND (bo.is_rejected IS NULL OR bo.IS_REJECTED = 'N')
|
|
|
22 |
ORDER BY bo.BOM_ID desc
|