select l.currency, l.credit_percent as _credit_percent
from iv_price_lists l, cr_items li
where l.list_id = li.latest_revision
and li.item_id = :list_id
select t.organization_id, t.currency, t.accepted_date,
t.vat_percent as cur_vat_percent, t.offer_id as offer_rev_id,
(t.amount_total - t.amount_sum) as sum_total_diff,
t.credit_percent as _credit_percent
from iv_offers t, cr_items i
where i.latest_revision = t.offer_id
and i.item_id = :offer_id
select i.name as file_name, r.content_length as file_length,
i.item_id as file_id
from cr_items i, cr_revisions r
where i.parent_id = :offer_id
and r.item_id = i.item_id
and i.publish_status <> 'expired'
select count(*) as invoice_count
from iv_invoice_items ii, iv_offer_items oi, iv_invoices i, cr_items cri
where ii.offer_item_id = oi.offer_item_id
and oi.offer_id = :offer_rev_id
and i.invoice_id = ii.invoice_id
and i.cancelled_p = 'f'
and cri.latest_revision = i.invoice_id
and not exists (select 1
from iv_invoices ci, cr_items cri
where ci.parent_invoice_id = i.invoice_id
and i.cancelled_p = 't'
and cri.latest_revision = ci.invoice_id)
select r.title, r.item_id
from cr_revisions r, cr_items i, pm_projects p, acs_data_links ar
where ar.object_id_one = :organization_id
and ar.object_id_two = r.revision_id
and i.latest_revision = r.revision_id
and p.project_id = r.revision_id
and i.item_id not in (select ar2.object_id_one
from acs_data_links ar2, cr_items oi, iv_offers o
where ar2.object_id_two = oi.item_id
and oi.latest_revision = o.offer_id)
order by r.title desc
select p.category_id, p.amount
from iv_prices p, cr_items i
where p.list_id = :list_id
and p.price_id = i.latest_revision
select r.title as project_name, r.item_id, p.project_code,
to_char(p.planned_end_date,'YYYY-MM-DD HH24:MI:SS') as project_date_ansi
from cr_revisions r, cr_items i, pm_projects p
where i.item_id = :_project_id
and i.latest_revision = r.revision_id
and p.project_id = r.revision_id
select r.title, r.description, r.item_id, ofi.offer_item_id,
ofi.item_units, ofi.price_per_unit, ofi.item_nr, ofi.comment,
ofi.rebate, ofi.vat, m.category_id, ofi.file_count, ofi.page_count
from iv_offer_items ofi, cr_items oi, acs_objects o, cr_revisions r,
category_object_map m
where o.object_id = ofi.offer_id
and o.package_id = :package_id
and oi.latest_revision = ofi.offer_id
and r.revision_id = ofi.offer_item_id
and oi.item_id = :offer_id
and m.object_id = ofi.offer_item_id
order by ofi.item_nr
select r.description as comment
from cr_revisions r, cr_items i
where r.revision_id = i.latest_revision
and i.item_id = :_project_id
select t.offer_id as offer_rev_id, r.title, r.description,
t.offer_nr, t.amount_total, t.vat, t.vat_percent, t.comment,
to_char(t.finish_date, 'YYYY-MM-DD HH24:MI:SS') as finish_ansi,
o.creation_user, p.first_names, p.last_name, t.reservation,
to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_ansi,
to_char(t.accepted_date, 'YYYY-MM-DD HH24:MI:SS') as accepted_ansi,
t.amount_sum as amount_sum_, t.payment_days, t.date_comment, t.show_sum_p
from iv_offers t, cr_revisions r, cr_items i, acs_objects o,
persons p
where r.revision_id = t.offer_id
and i.latest_revision = r.revision_id
and i.item_id = :offer_id
and o.object_id = i.item_id
and p.person_id = o.creation_user