Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* Find Package Version */
SELECT pv.PKG_VERSION,
           pv.PV_ID,
           pv.DLOCKED,
           pv.MODIFIED_STAMP,
           pv.COMMENTS,
           usr.FULL_NAME,
           usr.USER_EMAIL
  FROM PACKAGE_VERSIONS pv,
           USERS usr
 WHERE pv.PKG_ID = :PKG_ID
   AND pv.PKG_VERSION LIKE :PKG_VERSION
   AND pv.MODIFIER_ID = usr.USER_ID