Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Name Version List */
2 
SELECT bo.BOM_ID,
3 
	   bn.BOM_NAME,
4 
	   bo.BOM_VERSION,
5 
	   bo.BOM_LIFECYCLE,
6 
	   bo.IS_READONLY,
7 
	   bo.IS_REJECTED
8 
  FROM BOMS bo,
9 
  	   BOM_NAMES bn
10 
 WHERE bo.BOM_NAME_ID = bn.BOM_NAME_ID
11 
   AND bn.BOM_NAME_ID = :BOM_NAME_ID
12 
 ORDER BY UPPER(bo.BOM_VERSION) DESC, UPPER(bo.BOM_LIFECYCLE) DESC