Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Find FILES */
2 
SELECT qry.*, pkg.pkg_name, pv.pkg_version
3 
  FROM (
4 
 
5 
		/* Search Package(Module) files */
6 
		SELECT rc.FILE_NAME,
7 
			   rc.FILE_PATH,
8 
			   rc.CRC_CKSUM,
9 
			   rc.PV_ID
10 
		  FROM RELEASE_COMPONENTS rc
11 
		 WHERE UPPER( rc.FILE_NAME ) LIKE  UPPER( :FILE_NAME )
12 
 
13 
		UNION ALL
14 
 
15 
		/* Search Package(Module) files */
16 
		SELECT rc.FILE_NAME,
17 
			   rc.FILE_PATH,
18 
			   rc.CRC_CKSUM,
19 
			   rc.PV_ID
20 
		  FROM PRODUCT_COMPONENTS rc
21 
		 WHERE UPPER( rc.FILE_NAME ) LIKE  UPPER( :FILE_NAME )
22 
 
23 
 
24 
  	   ) qry,
25 
  	   PACKAGES pkg,
26 
	   PACKAGE_VERSIONS pv
27 
 WHERE pv.pkg_id = pkg.pkg_id
28 
   AND qry.pv_id = pv.pv_id
29 
   AND pkg.PKG_NAME LIKE :PKG_NAME
30 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
31 
   AND ROWNUM <= :PAGE_SIZE
32 
 
33 
 
34 
 
35 
 
36