Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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