Subversion Repositories DevTools

Rev

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

/* BOM Combo */
SELECT bo.BOM_ID,
           bn.BOM_NAME ||' '|| bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS ITEM_VALUE,
           DECODE ( :BOM_ID,
                                bo.BOM_ID, 'selected',
                                NULL ) AS SELECTED
  FROM BOMS bo,
           BOM_NAMES bn
 WHERE bo.BRANCH_ID = :BRANCH_ID   
   AND bo.BOM_NAME_ID = bn.BOM_NAME_ID
 ORDER BY UPPER(bn.BOM_NAME), bo.BOM_VERSION, bo.BOM_LIFECYCLE