Subversion Repositories DevTools

Rev

Rev 6873 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Find Package Version */
5759 dpurdie 2 
SELECT DISTINCT pv.PKG_VERSION,
3 
    pv.PV_ID,
4 
    pv.DLOCKED,
5 
    pv.MODIFIED_STAMP,
6 
    pv.COMMENTS,
7 
    NVL(usr.FULL_NAME, 'Unknown User') AS FULL_NAME,
8 
    usr.USER_EMAIL,
9 
    -- Field to assist in determining if the user can delete the version
10 
    pv.OWNER_ID,
11 
    pv.CREATOR_ID,
12 
    NVL2(rc.rtag_id,1,0) as inuse,
6623 dpurdie 13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age,
14 
    pm.code_lines,
7162 dpurdie 15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' WHEN 'F' THEN 'ForcedRipple' ELSE '' END ) as reason,
6623 dpurdie 16 
    bi.state,
17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
6707 dpurdie 18 
    pv.build_time,
6873 dpurdie 19 
    pln.NAME as licence,
20 
    pv.pkg_idext,
21 
    pv.build_type
119 ghuddy 22 
  FROM PACKAGE_VERSIONS pv,
5759 dpurdie 23 
       USERS usr,
6623 dpurdie 24 
       RELEASE_CONTENT rc,
25 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
26 
          where bi.state in ('C')
27 
          and bi.reason not in ('T')
28 
          group by pv_id
29 
        ) cbi,
30 
       BUILD_INSTANCES bi,
6707 dpurdie 31 
       package_metrics pm,
32 
       LICENCING pl,
33 
       LICENCES pln
119 ghuddy 34 
 WHERE pv.PKG_ID = :PKG_ID
35 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
5475 dpurdie 36 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
6623 dpurdie 37 
   AND pv.pv_id = rc.pv_id(+)
38 
   AND cbi.pv_id(+) = pv.pv_id
39 
   and cbi.build_id = bi.build_id(+)
40 
   AND pm.pv_id (+) = pv.pv_id
6707 dpurdie 41 
   and pl.PV_ID(+) = pv.pv_id
42 
   and pln.LICENCE(+) = pl.LICENCE
6623 dpurdie 43