Subversion Repositories DevTools

Rev

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

/* Product components */
SELECT pc.PV_ID, 
           pc.FILE_PATH,
           pc.FILE_NAME, 
           pc.BYTE_SIZE,
           pc.CRC_CKSUM,
           NULL AS CRC_MODCRC
  FROM PRODUCT_COMPONENTS pc
 WHERE pc.PV_ID = :PV_ID
   AND pc.OS_ID = :OS_ID
 ORDER BY UPPER(pc.FILE_PATH), UPPER(pc.FILE_NAME) NULLS FIRST