Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 19
Line 49... Line 49...
49 
		   AND bs.IS_DISPLAYED = 'Y'
 49 
		   AND bs.IS_DISPLAYED = 'Y'
50
50
51 
		  ) qry
 51 
		  ) qry
52 
 ORDER BY   	qry.STATE_SEQ,
 52 
 ORDER BY   	qry.STATE_SEQ,
53 
		UPPER(qry.BOM_NAME) NULLS FIRST,
 53 
		UPPER(qry.BOM_NAME) NULLS FIRST,
54 
    	 	qry.DATE_STAMP DESC
 54 
		qry.DATE_STAMP DESC,
- 
 
 55 
		(qry.BOM_VERSION) DESC,
- 
 
 56 
		 TO_NUMBER(qry.BOM_LIFECYCLE) DESC
- 
 
 57
55
58