Subversion Repositories DevTools

Rev

Rev 5759 | Rev 6707 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5759 Rev 6623
Line 8... Line 8...
8 
    usr.USER_EMAIL,
 8 
    usr.USER_EMAIL,
9 
    -- Field to assist in determining if the user can delete the version
 9 
    -- Field to assist in determining if the user can delete the version
10 
    pv.OWNER_ID,
 10 
    pv.OWNER_ID,
11 
    pv.CREATOR_ID,
 11 
    pv.CREATOR_ID,
12 
    NVL2(rc.rtag_id,1,0) as inuse,
 12 
    NVL2(rc.rtag_id,1,0) as inuse,
13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age
 13 
    trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age,
- 
 
 14 
    pm.code_lines,
- 
 
 15 
    (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' WHEN 'T' THEN 'Test' WHEN 'P' THEN 'Restored' ELSE '' END ) as reason,
- 
 
 16 
    bi.state,
- 
 
 17 
    (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
- 
 
 18 
    pv.build_time
14 
  FROM PACKAGE_VERSIONS pv,
 19 
  FROM PACKAGE_VERSIONS pv,
15 
       USERS usr,
 20 
       USERS usr,
16 
       RELEASE_CONTENT rc
 21 
       RELEASE_CONTENT rc,
- 
 
 22 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
- 
 
 23 
          where bi.state in ('C')
- 
 
 24 
          and bi.reason not in ('T')
- 
 
 25 
          group by pv_id
- 
 
 26 
        ) cbi,
- 
 
 27 
       BUILD_INSTANCES bi,
- 
 
 28 
       package_metrics pm
17 
 WHERE pv.PKG_ID = :PKG_ID
 29 
 WHERE pv.PKG_ID = :PKG_ID
18 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
 30 
   AND pv.PKG_VERSION LIKE :PKG_VERSION
19 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
 31 
   AND pv.MODIFIER_ID = usr.USER_ID(+)
20 
   AND pv.pv_id = rc.pv_id(+)
- 
 
21 

            32
            
   AND pv.pv_id = rc.pv_id(+)

          

          

            -
            
 

            33
            
   AND cbi.pv_id(+) = pv.pv_id

          

          

            -
            
 

            34
            
   and cbi.build_id = bi.build_id(+)

          

          

            -
            
 

            35
            
   AND pm.pv_id (+) = pv.pv_id

          

          

            -
            
 

            36
            
 

          

          

            -
            
 

            37