| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
3 |
3 |
<queryset> |
| |
4 |
4 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
5 |
5 |
|
| |
6 |
6 |
<fullquery name="package_info"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
select package_key, |
| |
9 |
9 |
acs_object.name(package_id) instance_name |
| |
10 |
10 |
from apm_packages |
| |
11 |
11 |
where package_id = :package_id |
| |
12 |
12 |
</querytext> |
| |
13 |
13 |
</fullquery> |
| |
14 |
14 |
|
| |
15 |
|
<fullquery name="parameter_table"> |
| |
16 |
|
<querytext> |
| |
17 |
|
select p.parameter_id, |
| |
18 |
|
p.parameter_name, |
| |
19 |
|
p.package_key, |
| |
20 |
|
nvl(p.description, 'No Description') description, |
| |
21 |
|
v.attr_value, |
| |
22 |
|
nvl(p.section_name, 'No Section Name') section_name |
| |
23 |
|
from apm_parameters p, |
| |
24 |
|
(select v.parameter_id, |
| |
25 |
|
v.attr_value |
| |
26 |
|
from apm_parameter_values v |
| |
27 |
|
where v.package_id = :package_id) v |
| |
28 |
|
where p.parameter_id = v.parameter_id(+) |
| |
29 |
|
and p.package_key = (select package_key from apm_packages where package_id = :package_id) |
| |
30 |
|
$additional_sql |
| |
31 |
|
</querytext> |
| |
32 |
|
</fullquery> |
| |
33 |
|
|
| |
34 |
15 |
</queryset> |
