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 r.title as project_name, r.item_id, p.project_code, r.description as comment,
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_item_id
and i.latest_revision = r.revision_id
and p.project_id = r.revision_id