Subversion Repositories DevTools

/* Find FILES */
SELECT qry.*, pkg.pkg_name, pv.pkg_version 
  FROM (
        
                /* Search Package(Module) files */
                SELECT rc.FILE_NAME,
                           rc.FILE_PATH,
                           rc.CRC_CKSUM,
                           rc.PV_ID
                  FROM RELEASE_COMPONENTS rc
                 WHERE UPPER( rc.FILE_NAME ) LIKE  UPPER( :FILE_NAME ) 
                 
                UNION ALL
                
                /* Search Package(Module) files */
                SELECT rc.FILE_NAME,
                           rc.FILE_PATH,
                           rc.CRC_CKSUM,
                           rc.PV_ID
                  FROM PRODUCT_COMPONENTS rc
                 WHERE UPPER( rc.FILE_NAME ) LIKE  UPPER( :FILE_NAME )
           
           
           ) qry, 
           PACKAGES pkg,
           PACKAGE_VERSIONS pv
 WHERE pv.pkg_id = pkg.pkg_id
   AND qry.pv_id = pv.pv_id
   AND pkg.PKG_NAME LIKE :PKG_NAME 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
   AND ROWNUM <= :PAGE_SIZE