Subversion Repositories DevTools

SELECT * from (
  SELECT p.PKG_NAME, pv.PKG_VERSION, pc.pv_id,
       '/' || REPLACE(NVL(pc.FILE_PATH,''),'\','/') ||pc.FILE_NAME as filename
    FROM RELEASE_COMPONENTS pc, PACKAGE_VERSIONS pv, packages p
    WHERE pc.pv_id = pv.pv_id
    and p.pkg_id = pv.pkg_id
    and pc.file_name is not null
    AND UPPER(p.pkg_name) like UPPER('/*PKG_NAME*/')
  ) 
  where upper(filename) like Upper('/*FILE_NAME*/')
  order by  pkg_version, upper(filename)