Search Results contract_rate




Overview
Explore in AI Chat

Overview

APPS.ICX_POR_EXT_ACTIVE_CONTRACTS is a database view owned by the APPS schema and registered in Oracle E-Business Suite under the FND Design Data reference ICX.ICX_POR_EXT_ACTIVE_CONTRACTS. It presents a flattened, denormalized projection of active supplier contract information for use by Internet Procurement catalog and sourcing functions. The view is designated Oracle Internal Use Only; Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. Its status is VALID and its view type is classified as Internal.

In the 12.1.1 and 12.2.2 releases, the view is predominantly consumed by the iProcurement and Purchasing integration layer to surface contract pricing, rate information, and supplier details to end users during requisition entry and catalog browsing. The inclusion of CONTRACT_RATE, CONTRACT_RATE_TYPE, and CONTRACT_RATE_DATE reflects the object's role in exposing exchange-rate-derived contract pricing, which is directly relevant to the search term "contract_rate." These columns allow callers to distinguish the raw unit price from the rate-converted contract price and to identify the conversion rate type and effective date applied.

Underlying Base Objects

The view is defined over several Purchasing and General Ledger base objects. Documented dependencies include:

The view references no other database objects and is not referenced by any database object, confirming it functions as a terminal read-only projection. The reliance on PO_QUOTATION_APPROVALS_ALL distinguishes it from generic contract views, restricting output to approved, active agreements.

Key Columns

Principal columns include CONTRACT_NUM, CONTRACT_LINE, CONTRACT_ID, and CONTRACT_LINE_ID, which identify the agreement and its lines. Item-level detail is exposed via ITEM_ID, ITEM_DESCRIPTION, CATEGORY_ID, and UNIT_OF_MEASURE. Pricing is represented by UNIT_PRICE, CURRENCY, CONTRACT_PRICE, and CONTRACT_CURRENCY.

The rate-related columns are central: CONTRACT_RATE holds the numeric conversion rate, CONTRACT_RATE_TYPE identifies the rate type from GL_DAILY_CONVERSION_TYPES, and CONTRACT_RATE_DATE records the effective date used for conversion. Supplier context is provided by SUPPLIER, SUPPLIER_ID, SUPPLIER_SITE_ID, and SUPPLIER_PART_NUMBER. Additional columns include PICTURE_URL, OPERATING_UNIT_ID, CREATION_DATE, and LAST_UPDATE_DATE.

Common Use Cases and Queries

A typical use is retrieving contract pricing with rate conversion details for a specific item and supplier.

SELECT contract_num, contract_line, item_description,
       unit_price, currency, contract_price, contract_currency,
       contract_rate_type, contract_rate_date, contract_rate
FROM   apps.icx_por_ext_active_contracts
WHERE  item_id = :p_item_id
AND    supplier_id = :p_supplier_id;

Another scenario audits rate types applied across operating units:

SELECT operating_unit_id, contract_rate_type,
       COUNT(*) rate_count, AVG(contract_rate) avg_rate
FROM   apps.icx_por_ext_active_contracts
WHERE  contract_rate_date >= :p_from_date
GROUP BY operating_unit_id, contract_rate_type;

Because the object is Oracle Internal Use Only, queries should be limited to supported application flows or controlled reporting environments.