Subversion Repositories DevTools

/* Package Details */
SELECT pv.pv_id, 
           pkg.pkg_id, 
           pkg.pkg_name, 
       pv.pkg_version, 
       pv.v_ext, 
       pv.modified_stamp, 
       pv.modifier_id,
       umd.user_name modifier, 
       umd.user_email AS modifier_email, 
       pv.created_stamp,
       ucr.user_name AS creator, 
       ucr.user_email AS creator_email, 
       onr.full_name AS owner, 
       onr.user_email AS owner_email, 
       pv.dlocked,
       rel.proj_id, 
       rel.rtag_id, 
       rel.rtag_name, 
       pv.comments, 
       pv.pkg_label, 
       pv.src_path, 
       pv.pv_description, 
       pv.is_patch, 
       lpv.pkg_version AS previous_version, 
       pv.last_pv_id,
           pv.release_notes_info,
           pv.is_obsolete,
           pv.obsolete_comments,
           pv.build_type,
           pv.change_type
  FROM package_versions pv,
       package_versions lpv,
       PACKAGES pkg,
       release_tags rel,
       users umd,
       users ucr,
       users onr
 WHERE pkg.pkg_id = pv.pkg_id
   AND pv.last_pv_id = lpv.pv_id (+)
   AND rel.rtag_id (+) = pv.released_at
   AND umd.user_id (+) = pv.modifier_id
   AND ucr.user_id (+) = pv.creator_id
   AND onr.user_id (+) = pv.owner_id
   AND pv.pv_id = :PV_ID