SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, pv.v_ext, ji.*
  FROM jira_issues ji,
       packages pkg,
       package_versions pv
 WHERE pv.pkg_id = pkg.pkg_id
   AND ji.pv_id = pv.pv_id
   AND ji.ISS_KEY IN ( /*ISS_ID_LIST*/ )  
ORDER BY ji.ISS_KEY, UPPER(pkg.pkg_name)    
   
   