/* 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