Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Module components */
2 
SELECT rc.PV_ID,
3 
	   rc.FILE_PATH,
4 
	   rc.FILE_NAME,
5 
	   rc.BYTE_SIZE,
6 
	   rc.CRC_CKSUM,
7 
	   rc.CRC_MODCRC
8 
  FROM RELEASE_COMPONENTS rc
9 
 WHERE rc.PV_ID = :PV_ID
10 
 ORDER BY UPPER(rc.FILE_PATH), UPPER(rc.FILE_NAME) NULLS FIRST