Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1 
/* Product components */
2 
SELECT pc.PV_ID,
3 
	   pc.FILE_PATH,
4 
	   pc.FILE_NAME,
5 
	   pc.BYTE_SIZE,
6 
	   pc.CRC_CKSUM,
7 
	   NULL AS CRC_MODCRC
8 
  FROM PRODUCT_COMPONENTS pc
9 
 WHERE pc.PV_ID = :PV_ID
10 
   AND pc.OS_ID = :OS_ID
11 
 ORDER BY UPPER(pc.FILE_PATH), UPPER(pc.FILE_NAME) NULLS FIRST