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 State Explorer */
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 
	   bo.BOM_COMMENTS,
9 
	   bs.DATE_STAMP AS ARRIVED_DATE,
10 
	   bs.IS_DISPLAYED,
11 
	   usr.FULL_NAME,
12 
	   usr.USER_EMAIL
13 
  FROM BOMS bo,
14 
  	   BOM_STATE bs,
15 
	   BOM_NAMES bn,
16 
	   USERS usr
17 
 WHERE bo.BOM_NAME_ID = bn.BOM_NAME_ID
18 
   AND bs.BOM_ID = bo.BOM_ID
19 
   AND bo.BRANCH_ID = :BRANCH_ID
20 
   AND bs.STATE_ID = :STATE_ID
21 
   AND bs.USER_ID = usr.USER_ID
22 
   AND bo.IS_HIDDEN = 'N'
23 
 ORDER BY UPPER(bn.BOM_NAME),
24 
		  UPPER(bo.BOM_VERSION ||'.'|| bo.BOM_LIFECYCLE) DESC