Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Find Package Version */
2 
SELECT pv.PKG_VERSION,
3 
	   pv.PV_ID,
4 
	   pv.DLOCKED,
5 
	   pv.MODIFIED_STAMP,
6 
	   pv.COMMENTS,
7 
	   usr.FULL_NAME,
8 
	   usr.USER_EMAIL
9 
  FROM PACKAGE_VERSIONS pv,
10 
  	   USERS usr
11 
 WHERE pv.PKG_ID = :PKG_ID
12 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
13 
   AND pv.MODIFIER_ID = usr.USER_ID
14 
 
15