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

   
   
   
  