Subversion Repositories DevTools

Rev

Rev 5950 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5950 Rev 5975
Line 18... Line 18...
18 
		 WHERE pv.pv_id not in (select pv_id from PLANNED )
 18 
		 WHERE pv.pv_id not in (select pv_id from PLANNED )
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 WORK_IN_PROGRESS )
20 
           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 )
21 
           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)
22 
           AND pv.pv_id not in ( SELECT pv_id FROM PACKAGE_PROCESSES )
 22 
           AND pv.pv_id not in ( SELECT pv_id FROM PACKAGE_PROCESSES )
23 
         --AND pv_id not in (select prod_id from deployment_manager.os_contents )
 23 
           AND pv.pv_id not in (select prod_id from DEPLOYMENT_MANAGER.OS_CONTENTS )
- 
 
 24 
           AND pv.pv_id not in (select prod_id from DEPLOYMENT_MANAGER.BASE_ENV_CONTENTS )
24 
           AND pv.MODIFIER_ID = :USER_ID
 25 
           AND pv.MODIFIER_ID = :USER_ID
25 
           AND pv.dlocked        != 'Y'
 26 
           AND pv.dlocked        != 'Y'
26
27
27 
       ) rel,
 28 
       ) rel,
28 
       PACKAGES pkg
 29 
       PACKAGES pkg