Subversion Repositories DevTools

Rev

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

Rev 13 Rev 29
Line 17... Line 17...
17 
		   AND bo.BOM_NAME_ID = :BOM_NAME_ID
 17 
		   AND bo.BOM_NAME_ID = :BOM_NAME_ID
18 
		   AND bo.BRANCH_ID = :BRANCH_ID
18 
		   AND bo.BRANCH_ID = :BRANCH_ID
19 
	  ) qry,
 19 
	  ) qry,
20 
	  BOMS bo
 20 
	  BOMS bo
21 
 WHERE qry.BOM_ID = bo.BOM_ID
21 
 WHERE qry.BOM_ID = bo.BOM_ID
22 
ORDER BY qry.VERSION, qry.BOM_ID
 - 
 
23 

            22
            
ORDER BY bo.BOM_VERSION, TO_NUMBER(bo.BOM_LIFECYCLE), qry.BOM_ID

          

          

            -
            
 

            23
            

          

          

            24
            

            24