Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6770 dpurdie 1 
/* Release Package Versions */
2 
SELECT rc.rtag_id,
3 
  pv.PV_ID,
4 
  pv.PKG_ID,
5 
  pv.PKG_VERSION,
6 
  DECODE ( pv.pv_id, :COMPARE_PV_ID, 'selected', NULL ) AS selected,
7 
  rt.RTAG_NAME,
8 
  p.PROJ_NAME,
9 
  p.PROJ_NAME || ' | ' || rt.RTAG_NAME || ' | ' || pv.PKG_VERSION as text
10 
FROM RELEASE_CONTENT rc,
11 
  package_versions pv,
12 
  RELEASE_TAGS rt,
13 
  PROJECTS p
14 
WHERE rc.pv_id                       = pv.PV_ID
15 
AND pv.pkg_id                        = :PKG_ID
16 
AND NVL( pv.v_ext, '|LINK_A_NULL|' ) = NVL( :V_EXT, '|LINK_A_NULL|')
17 
AND rt.RTAG_ID                       = rc.rtag_id
18 
AND rt.PROJ_ID                       = p.PROJ_ID
19 
order by UPPER(PROJ_NAME) , Upper(RTAG_NAME)
20