Subversion Repositories DevTools

Rev

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

Rev 5901 Rev 5950
Line 7... Line 7...
7 
-- =====================================================
 7 
-- =====================================================
8 
SELECT pkg.PKG_NAME,
 8 
SELECT pkg.PKG_NAME,
9 
       rel.PKG_VERSION,
 9 
       rel.PKG_VERSION,
10 
       rel.PV_ID,
 10 
       rel.PV_ID,
11 
       rel.PKG_ID,
 11 
       rel.PKG_ID,
- 
 
 12 
       rel.MODIFIED_STAMP,
12 
       SUBSTR(rel.COMMENTS, 1, 60) AS COMMENTS
 13 
       SUBSTR(rel.COMMENTS, 1, 60) AS COMMENTS
13 
  FROM (
 14 
  FROM (
14 
        /* Get Dangling Packages */
 15 
        /* Get Dangling Packages */
15 
        SELECT pv.PV_ID, pv.PKG_ID, pv.PKG_VERSION, pv.COMMENTS
 16 
        SELECT pv.PV_ID, pv.PKG_ID, pv.PKG_VERSION, pv.COMMENTS, pv.MODIFIED_STAMP
16 
          FROM PACKAGE_VERSIONS pv
 17 
          FROM PACKAGE_VERSIONS pv
17 
		 WHERE pv.pv_id not in (select pv_id from PLANNED )
 18 
		 WHERE pv.pv_id not in (select pv_id from PLANNED )
18 
           AND pv.pv_id not in (select pv_id from WORK_IN_PROGRESS )
 19 
           AND pv.pv_id not in (select pv_id from WORK_IN_PROGRESS )
19 
           AND pv.pv_id not in (select pv_id from RELEASE_CONTENT )
 20 
           AND pv.pv_id not in (select pv_id from RELEASE_CONTENT )
20 
           AND pv.pv_id not in (select rtd_id from RUNTIME_DEPENDENCIES)
 21 
           AND pv.pv_id not in (select rtd_id from RUNTIME_DEPENDENCIES)