Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Details */
2 
SELECT bo.*,
3 
       bn.BOM_NAME,
4 
	   bec.BASE_ENV_COUNT
5 
  FROM BOMS bo,
6 
  	   BOM_NAMES bn,
7 
	   (
8 
	    SELECT COUNT(*) AS BASE_ENV_COUNT,
9 
			   be.BOM_ID
10 
		  FROM BASE_ENV be
11 
		 WHERE be.BOM_ID = :BOM_ID
12 
		 GROUP BY be.BOM_ID
13 
	   ) bec
14 
 WHERE bo.BOM_NAME_ID = bn.BOM_NAME_ID
15 
   AND bo.BOM_ID = :BOM_ID
16 
   And bec.BOM_ID (+) = bo.BOM_ID
17