| Line -... |
Line 1... |
| - |
|
1 |
select * from (
|
| - |
|
2 |
|
| - |
|
3 |
-- Select items from the PLANND table
|
| - |
|
4 |
-- These will already be marked fro merging, possibly from a previous screen refresh
|
| - |
|
5 |
--
|
| 1 |
select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
|
6 |
select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
|
| 2 |
TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp,
|
7 |
TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp,
|
| 3 |
pvc.pv_id as new_pv_id,
|
8 |
pvc.pv_id as new_pv_id,
|
| 4 |
pvc.pkg_version as new_pkg_version,
|
9 |
pvc.pkg_version as new_pkg_version,
|
| 5 |
TO_CHAR( pvc.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS new_created_stamp
|
10 |
TO_CHAR( pvc.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS new_created_stamp,
|
| - |
|
11 |
TRUNC (sysdate - pvc.created_stamp) as NEW_AGE,
|
| - |
|
12 |
'A' as eTYPE,
|
| - |
|
13 |
pvc.created_stamp AS sortDate
|
| - |
|
14 |
|
| - |
|
15 |
from release_content rc, package_versions pv , package_versions pvc, packages p, views v, planned p
|
| - |
|
16 |
where rc.rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
|
| - |
|
17 |
and p.pkg_id = pv.pkg_id
|
| - |
|
18 |
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
|
| - |
|
19 |
and pvc.pkg_id = pv.pkg_id
|
| - |
|
20 |
--and pvc.created_stamp > pv.created_stamp
|
| - |
|
21 |
--and pvc.build_type != 'Y'
|
| - |
|
22 |
--and pvc.dlocked = 'Y'
|
| - |
|
23 |
and rc.base_view_id = v.view_id
|
| - |
|
24 |
and p.rtag_id = :RTAG_ID
|
| - |
|
25 |
and p.pv_id = pvc.pv_id
|
| - |
|
26 |
and p.operation ='A'
|
| - |
|
27 |
|
| - |
|
28 |
union
|
| - |
|
29 |
|
| - |
|
30 |
-- Select packages that have a more recently ceated packages
|
| - |
|
31 |
--
|
| - |
|
32 |
select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
|
| - |
|
33 |
TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp,
|
| - |
|
34 |
pvc.pv_id as new_pv_id,
|
| - |
|
35 |
pvc.pkg_version as new_pkg_version,
|
| - |
|
36 |
TO_CHAR( pvc.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS new_created_stamp,
|
| - |
|
37 |
TRUNC (sysdate - pvc.created_stamp) as NEW_AGE,
|
| - |
|
38 |
'-' as eTYPE,
|
| - |
|
39 |
pvc.created_stamp AS sortDate
|
| - |
|
40 |
|
| 6 |
from release_content rc, package_versions pv , package_versions pvc, packages p, views v
|
41 |
from release_content rc, package_versions pv , package_versions pvc, packages p, views v
|
| 7 |
where rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
|
42 |
where rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
|
| 8 |
and p.pkg_id = pv.pkg_id
|
43 |
and p.pkg_id = pv.pkg_id
|
| 9 |
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
|
44 |
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
|
| 10 |
and pvc.pkg_id = pv.pkg_id
|
45 |
and pvc.pkg_id = pv.pkg_id
|
| 11 |
and pvc.created_stamp > pv.created_stamp
|
46 |
and pvc.created_stamp > pv.created_stamp
|
| 12 |
and pvc.build_type != 'Y'
|
47 |
and pvc.build_type != 'Y'
|
| 13 |
and pvc.dlocked = 'Y'
|
48 |
and pvc.dlocked = 'Y'
|
| 14 |
and rc.base_view_id = v.view_id
|
49 |
and rc.base_view_id = v.view_id
|
| - |
|
50 |
)
|
| 15 |
order by UPPER(p.pkg_name), pvc.created_stamp desc
|
51 |
order by UPPER(pkg_name), sortDate desc, ETYPE DESC
|
| - |
|
52 |
|
| - |
|
53 |
|