Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
13 rsolanki 1 
/* Bom Names List */
2 
SELECT DISTINCT
3 
	   bn.BOM_NAME_ID,
4 
	   bn.BOM_NAME
5 
  FROM BRANCHES br,
6 
  	   BOMS bo,
7 
	   BOM_NAMES bn
8 
 WHERE bo.BRANCH_ID = br.BRANCH_ID
9 
   AND bo.BOM_NAME_ID = bn.BOM_NAME_ID
10 
   AND (
11 
		 ( br.PROJ_ID = :PROJ_ID	  AND  :PROJ_ID IS NOT NULL) OR
12 
		 ( br.PROJ_ID = br.PROJ_ID     AND  :PROJ_ID IS NULL )
13 
	   )
14 
 ORDER BY UPPER(bn.BOM_NAME)
15