| 6970 |
dpurdie |
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 |
--
|
| 6951 |
dpurdie |
6 |
select rc.pv_id, v.view_name, pv.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext,
|
|
|
7 |
TO_CHAR( pv.created_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS created_stamp,
|
|
|
8 |
pvc.pv_id as new_pv_id,
|
|
|
9 |
pvc.pkg_version as new_pkg_version,
|
| 6970 |
dpurdie |
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 |
|
| 6951 |
dpurdie |
41 |
from release_content rc, package_versions pv , package_versions pvc, packages p, views v
|
|
|
42 |
where rtag_id = :RTAG_ID and rc.sdktag_id is null and pv.pv_id = rc.pv_id
|
|
|
43 |
and p.pkg_id = pv.pkg_id
|
|
|
44 |
and NVL(pvc.v_ext, 'isNULL') = NVL(pv.v_ext, 'isNULL')
|
|
|
45 |
and pvc.pkg_id = pv.pkg_id
|
|
|
46 |
and pvc.created_stamp > pv.created_stamp
|
|
|
47 |
and pvc.build_type != 'Y'
|
|
|
48 |
and pvc.dlocked = 'Y'
|
|
|
49 |
and rc.base_view_id = v.view_id
|
| 6970 |
dpurdie |
50 |
)
|
|
|
51 |
order by UPPER(pkg_name), sortDate desc, ETYPE DESC
|
|
|
52 |
|
|
|
53 |
|