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 Combo */
2 
SELECT bo.BOM_ID,
3 
	   bn.BOM_NAME ||' '|| bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS ITEM_VALUE,
4 
	   DECODE ( :BOM_ID,
5 
	   			bo.BOM_ID, 'selected',
6 
				NULL ) AS SELECTED
7 
  FROM BOMS bo,
8 
  	   BOM_NAMES bn
9 
 WHERE bo.BRANCH_ID = :BRANCH_ID
10 
   AND bo.BOM_NAME_ID = bn.BOM_NAME_ID
11 
 ORDER BY UPPER(bn.BOM_NAME), bo.BOM_VERSION, bo.BOM_LIFECYCLE