Subversion Repositories DevTools

Rev

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

/* Bom Name Version List */
SELECT bo.BOM_ID,
           bn.BOM_NAME,
           bo.BOM_VERSION,
           bo.BOM_LIFECYCLE,
           bo.IS_READONLY,
           bo.IS_REJECTED
  FROM BOMS bo,
           BOM_NAMES bn
 WHERE bo.BOM_NAME_ID = bn.BOM_NAME_ID 
   AND bn.BOM_NAME_ID = :BOM_NAME_ID
 ORDER BY UPPER(bo.BOM_VERSION) DESC, UPPER(bo.BOM_LIFECYCLE) DESC