| 119 |
ghuddy |
1 |
SELECT rel.world_id, rel.WORLD_NAME, rel.WORLD_DESC,
|
|
|
2 |
proj.proj_name, vt.vtree_name, rt.rtag_name, rt.OFFICIAL,
|
|
|
3 |
rt.rtag_id, pv.pv_id, pkg.pkg_name, pv.pkg_version,
|
|
|
4 |
DECODE(rel.world_id,
|
|
|
5 |
NULL, DECODE (rt.rtag_id,
|
|
|
6 |
:RTAG_ID, 'checked',
|
|
|
7 |
NULL ),
|
|
|
8 |
myw.checked
|
|
|
9 |
) AS checked,
|
|
|
10 |
DECODE(pv.pv_id,
|
|
|
11 |
:PV_ID, 'form_item',
|
|
|
12 |
'err_alert'
|
|
|
13 |
) AS version_style
|
|
|
14 |
FROM release_content rc,
|
|
|
15 |
release_tags rt,
|
|
|
16 |
vtrees vt,
|
|
|
17 |
projects proj,
|
|
|
18 |
package_versions pv,
|
|
|
19 |
package_versions opv,
|
|
|
20 |
packages pkg,
|
|
|
21 |
(
|
|
|
22 |
SELECT MAX(rtag.rtag_id) AS rtag_id, rtag.vtree_id, wd.WORLD_ID, wd.WORLD_NAME, wd.WORLD_DESC
|
|
|
23 |
FROM release_tags rtag,
|
|
|
24 |
vtrees_world vtw,
|
|
|
25 |
worlds wd
|
|
|
26 |
WHERE rtag.vtree_id = vtw.VTREE_ID (+)
|
|
|
27 |
AND vtw.WORLD_ID = wd.WORLD_ID (+)
|
|
|
28 |
GROUP BY rtag.VTREE_ID, wd.WORLD_ID, wd.WORLD_NAME, wd.WORLD_DESC
|
|
|
29 |
) rel,
|
|
|
30 |
(
|
|
|
31 |
/* Find My World for RTAG_ID */
|
|
|
32 |
SELECT 'checked' AS checked, vtw.world_id, rt.rtag_id
|
|
|
33 |
FROM vtrees_world vtw,
|
|
|
34 |
release_tags rt
|
|
|
35 |
WHERE rt.VTREE_ID = vtw.VTREE_ID
|
|
|
36 |
AND rt.rtag_id = :RTAG_ID
|
|
|
37 |
) myw
|
|
|
38 |
WHERE rt.VTREE_ID = vt.VTREE_ID
|
|
|
39 |
AND rc.rtag_id = rt.rtag_id
|
|
|
40 |
AND rc.pv_id = pv.pv_id
|
|
|
41 |
AND vt.PROJ_ID = proj.proj_id
|
|
|
42 |
AND vt.HIDE = 'N'
|
|
|
43 |
AND rt.rtag_id = rel.rtag_id
|
|
|
44 |
AND opv.pv_id = :PV_ID
|
|
|
45 |
AND pv.pkg_id = pkg.pkg_id
|
|
|
46 |
AND opv.pkg_id = pv.pkg_id
|
|
|
47 |
AND NVL(opv.v_ext, '|LINK_A_NULL|') = NVL(pv.v_ext, '|LINK_A_NULL|')
|
|
|
48 |
AND myw.world_id (+) = rel.world_id
|
|
|
49 |
/*------- OFFICIAL FILTER ----- */
|
|
|
50 |
AND ( ( rt.OFFICIAL = 'N' AND :OFFICIAL_FILTER = 0 ) -- Show Unofficials
|
|
|
51 |
OR ( rt.OFFICIAL = 'Y' AND :OFFICIAL_FILTER = 1 ) -- Show Officials
|
|
|
52 |
OR ( :OFFICIAL_FILTER = -1 ) -- Show All
|
|
|
53 |
)
|
|
|
54 |
/*------------------------------*/
|
|
|
55 |
ORDER BY UPPER(rel.world_name), UPPER(proj.proj_name), UPPER(vt.vtree_name), UPPER(rt.rtag_name)
|