| 5901 |
dpurdie |
1 |
-- =====================================================
|
|
|
2 |
-- UserWipUserDangle.sql
|
|
|
3 |
-- Keep in step with 'WorkNotInProgressByUser.sql'
|
|
|
4 |
--
|
|
|
5 |
-- Used by index.asp to list UnRelease Package Versions
|
|
|
6 |
-- modified by the user, but not in use anywhere
|
|
|
7 |
-- =====================================================
|
|
|
8 |
SELECT pkg.PKG_NAME,
|
|
|
9 |
rel.PKG_VERSION,
|
|
|
10 |
rel.PV_ID,
|
|
|
11 |
rel.PKG_ID,
|
| 5950 |
dpurdie |
12 |
rel.MODIFIED_STAMP,
|
| 5901 |
dpurdie |
13 |
SUBSTR(rel.COMMENTS, 1, 60) AS COMMENTS
|
|
|
14 |
FROM (
|
|
|
15 |
/* Get Dangling Packages */
|
| 5950 |
dpurdie |
16 |
SELECT pv.PV_ID, pv.PKG_ID, pv.PKG_VERSION, pv.COMMENTS, pv.MODIFIED_STAMP
|
| 5901 |
dpurdie |
17 |
FROM PACKAGE_VERSIONS pv
|
|
|
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 )
|
|
|
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)
|
|
|
22 |
AND pv.pv_id not in ( SELECT pv_id FROM PACKAGE_PROCESSES )
|
| 5975 |
dpurdie |
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 )
|
| 5901 |
dpurdie |
25 |
AND pv.MODIFIER_ID = :USER_ID
|
|
|
26 |
AND pv.dlocked != 'Y'
|
|
|
27 |
|
|
|
28 |
) rel,
|
|
|
29 |
PACKAGES pkg
|
|
|
30 |
WHERE rel.PKG_ID = pkg.PKG_ID
|
|
|
31 |
ORDER BY UPPER(pkg.PKG_NAME)
|
|
|
32 |
|