| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
<queryset> |
| |
3 |
3 |
|
| |
4 |
4 |
<fullquery name="invoice_data"> |
| |
5 |
5 |
<querytext> |
| |
6 |
6 |
|
| |
7 |
|
select i.invoice_nr, i.organization_id, i.parent_invoice_id, |
| |
|
7 |
select i.invoice_nr, i.organization_id, i.parent_invoice_id, i.invoice_nr, |
| |
8 |
8 |
i.total_amount, i.recipient_id, i.organization_id |
| |
9 |
9 |
from iv_invoices i, cr_items ii |
| |
10 |
10 |
where ii.latest_revision = i.invoice_id |
| |
11 |
11 |
and ii.item_id = :invoice_id |
| |
12 |
12 |
|
| |
13 |
13 |
</querytext> |
| |
14 |
14 |
</fullquery> |
| |
15 |
15 |
|
| |
16 |
16 |
</queryset> |
