Subversion Repositories DevTools

/* Find Package Version */
SELECT DISTINCT pv.PKG_VERSION,
    pv.PV_ID,
    pv.DLOCKED,
    pv.MODIFIED_STAMP,
    pv.COMMENTS,
    NVL(usr.FULL_NAME, 'Unknown User') AS FULL_NAME,
    usr.USER_EMAIL,
    -- Field to assist in determining if the user can delete the version
    pv.OWNER_ID,
    pv.CREATOR_ID,
    NVL2(rc.rtag_id,1,0) as inuse,
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age
  FROM PACKAGE_VERSIONS pv,
       USERS usr,
       RELEASE_CONTENT rc
 WHERE pv.PKG_ID = :PKG_ID
   AND pv.PKG_VERSION LIKE :PKG_VERSION
   AND pv.MODIFIER_ID = usr.USER_ID(+)
   AND pv.pv_id = rc.pv_id(+)