Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* Bom Tree Combo */
2 
SELECT DISTINCT BOM_ID,
3 
	   BOM_VERSION,
4 
	   DECODE( BOM_ID,
5 
	   		   :COMPARE_BOM_ID, 'selected',
6 
			   NULL ) AS SELECTED
7 
FROM
8 
(
9 
 
10 
SELECT bo.BOM_ID,
11 
	   bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS BOM_VERSION,
12 
	   DECODE( bo.BOM_ID,
13 
	   		   :COMPARE_BOM_ID, 'selected',
14 
			   NULL ) AS SELECTED
15 
 
16 
  FROM (
17 
		SELECT bo.BOM_ID, bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE AS VERSION
18 
		  FROM BOMS bo, BOM_STATE bs, PRODUCTION_BOM pm
19 
		 WHERE bo.BRANCH_ID = :BRANCH_ID
20 
		 AND bs.STATE_ID = pm.STATE_ID
21 
		 AND bs.BOM_ID = bo.BOM_ID
22 
	  ) qry,
23 
	  BOMS bo
24 
 WHERE qry.BOM_ID = bo.BOM_ID
25 
)
26 
ORDER BY BOM_VERSION desc