Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Tree Combo */
2 
SELECT bo.BOM_ID,
3 
	   bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS BOM_VERSION,
4 
	   DECODE( bo.BOM_ID,
5 
	   		   :COMPARE_BOM_ID, 'selected',
6 
			   NULL ) AS SELECTED
7 
  FROM (
8 
		SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
9 
		  FROM BOMS bo
10 
		 WHERE bo.BOM_VERSION = :BOM_VERSION
11 
		   AND bo.BOM_NAME_ID = :BOM_NAME_ID
12 
		   AND bo.BRANCH_ID = :BRANCH_ID
13 
		UNION
14 
		SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
15 
		  FROM BOMS bo
16 
		 WHERE bo.BOM_VERSION LIKE :LIKE_BOM_VERSION
17 
		   AND bo.BOM_NAME_ID = :BOM_NAME_ID
18 
		   AND bo.BRANCH_ID = :BRANCH_ID
19 
	  ) qry,
20 
	  BOMS bo
21 
 WHERE qry.BOM_ID = bo.BOM_ID
29 jtweddle 22 
ORDER BY bo.BOM_VERSION, TO_NUMBER(bo.BOM_LIFECYCLE), qry.BOM_ID