Subversion Repositories DevTools

Rev

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

Rev 23 Rev 29
Line 5... Line 5...
5 
	   			BOM_ID, 'selected',
 5 
	   			BOM_ID, 'selected',
6 
				NULL ) AS SELECTED
 6 
				NULL ) AS SELECTED
7 
FROM BOMS, BOM_NAMES
 7 
FROM BOMS, BOM_NAMES
8 
WHERE BRANCH_ID =:BRANCH_ID
 8 
WHERE BRANCH_ID =:BRANCH_ID
9 
AND BOM_NAMES.BOM_NAME_ID = BOMS.BOM_NAME_ID
 9 
AND BOM_NAMES.BOM_NAME_ID = BOMS.BOM_NAME_ID
10 
ORDER BY BOM_ID
 - 
 
11 

            10
            
ORDER BY UPPER(BOM_NAME), BOM_VERSION desc, TO_NUMBER(BOM_LIFECYCLE) desc

          

          

            -
            
 

            11
            

          

          

            12
            

            12