Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Recent BOMs in Branch */
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 (
9 
   		/* Head BOMs  */
10 
 
11 
		SELECT bo.BOM_ID
12 
		  FROM BOMS bo
13 
		 WHERE bo.BRANCH_ID = :BRANCH_ID
14 
 
15 
		MINUS
16 
 
17 
		SELECT bo.PARENT_BOM_ID AS BOM_ID
18 
		  FROM BOMS bo
19 
		 WHERE bo.BRANCH_ID = :BRANCH_ID
20 
		   AND bo.BOM_ID != bo.PARENT_BOM_ID
21 
 
22 
   	   ) hb,
23 
	   BOM_NAMES bn,
24 
	   BOMS bo
25 
 WHERE bo.BOM_ID = hb.BOM_ID
26 
   AND bo.BOM_NAME_ID = bn.BOM_NAME_ID
27 
 ORDER BY UPPER(bn.BOM_NAME), UPPER(bo.BOM_VERSION ||' '|| bo.BOM_LIFECYCLE ) DESC