| 119 |
ghuddy |
1 |
SELECT DISTINCT prj.proj_name, rt.rtag_name, vw.view_name, pv.pv_id,
|
|
|
2 |
pkg.pkg_name, pv.pkg_version, pv.modified_stamp,
|
|
|
3 |
act.description, pv.comments
|
|
|
4 |
FROM package_versions pv,
|
|
|
5 |
PACKAGES pkg,
|
|
|
6 |
release_content rc,
|
|
|
7 |
views vw,
|
|
|
8 |
release_tags rt,
|
|
|
9 |
projects prj,
|
|
|
10 |
action_log act
|
|
|
11 |
WHERE pv.modified_stamp >= TO_DATE (:from_date, 'DD/MM/YYYY')
|
|
|
12 |
AND pv.modified_stamp <= TO_DATE (:TO_DATE, 'DD/MM/YYYY') + 1
|
|
|
13 |
AND pv.dlocked = 'Y'
|
|
|
14 |
AND pv.comments <> 'Rippled Build.'
|
|
|
15 |
AND pkg.pkg_id = pv.pkg_id
|
|
|
16 |
AND rc.pv_id(+) = pv.pv_id
|
|
|
17 |
AND rt.rtag_id(+) = rc.rtag_id
|
|
|
18 |
AND prj.proj_id(+) = rt.proj_id
|
|
|
19 |
AND vw.view_id(+) = rc.base_view_id
|
|
|
20 |
AND act.pv_id = pv.pv_id
|
|
|
21 |
AND act.acttype_id = 6
|
|
|
22 |
ORDER BY act.description, pkg.pkg_name, pv.pkg_version, rt.rtag_name
|