| Line 15... |
Line 15... |
| 15 |
FROM PACKAGE_VERSIONS pv
|
15 |
FROM PACKAGE_VERSIONS pv
|
| 16 |
WHERE pv.pv_id not in (select pv_id from PLANNED )
|
16 |
WHERE pv.pv_id not in (select pv_id from PLANNED )
|
| 17 |
AND pv.pv_id not in (select pv_id from WORK_IN_PROGRESS )
|
17 |
AND pv.pv_id not in (select pv_id from WORK_IN_PROGRESS )
|
| 18 |
AND pv.pv_id not in (select pv_id from RELEASE_CONTENT )
|
18 |
AND pv.pv_id not in (select pv_id from RELEASE_CONTENT )
|
| 19 |
AND pv.pv_id not in (select rtd_id from RUNTIME_DEPENDENCIES)
|
19 |
AND pv.pv_id not in (select rtd_id from RUNTIME_DEPENDENCIES)
|
| 20 |
AND pv.pv_id not in ( SELECT pv_id FROM PACKAGE_PROCESSES )
|
20 |
AND pv.pv_id not in ( select pv_id from PACKAGE_PROCESSES )
|
| 21 |
--AND pv_id not in (select prod_id from deployment_manager.os_contents )
|
21 |
AND pv.pv_id not in (select prod_id from DEPLOYMENT_MANAGER.OS_CONTENTS )
|
| - |
|
22 |
AND pv.pv_id not in (select prod_id from DEPLOYMENT_MANAGER.BASE_ENV_CONTENTS )
|
| 22 |
AND pv.MODIFIER_ID = :USER_ID
|
23 |
AND pv.MODIFIER_ID = :USER_ID
|
| 23 |
AND pv.dlocked != 'Y'
|
24 |
AND pv.dlocked != 'Y'
|
| 24 |
|
- |
|
| 25 |
) rel,
|
25 |
) rel,
|
| 26 |
USERS usr
|
26 |
USERS usr
|
| 27 |
WHERE rel.MODIFIER_ID = usr.USER_ID
|
27 |
WHERE rel.MODIFIER_ID = usr.USER_ID
|
| 28 |
GROUP BY usr.USER_ID, usr.FULL_NAME, usr.USER_EMAIL
|
28 |
GROUP BY usr.USER_ID, usr.FULL_NAME, usr.USER_EMAIL
|
| 29 |
|
29 |
|