Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Version Tree */
2 
SELECT bo.BOM_ID,
3 
	   bo.BOM_VERSION,
4 
	   bo.BOM_LIFECYCLE,
5 
	   bo.IS_READONLY,
6 
	   bo.IS_REJECTED
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
22 
ORDER BY qry.VERSION, qry.BOM_ID