Search Results contract_closed_code




Overview
Explore in AI Chat

Overview

ICX_POR_EXT_CONTRACTS is an APPS-owned database view in Oracle iProcurement (ICX) that exposes externally sourced contract information originating from Oracle Purchasing. It presents a flattened, read-optimized representation of blanket purchase agreement (BPA) and contract headers and lines, joined to supplier, unit-of-measure, currency, and financials system parameter data. The view is named with the "EXT" prefix, indicating its role in the external catalog and contract sourcing flow that iProcurement uses to surface negotiated pricing to requisitioning users.

Within Oracle EBS 12.1.1 and 12.2.2, ICX_POR_EXT_CONTRACTS serves as a reporting and integration surface. It allows purchasing, sourcing, and procurement analysts to query contract pricing, validity windows, and supplier details without navigating the multi-table structure of the PO schema directly. The view carries a status of VALID in the ETRM repository.

Underlying Base Objects

The view text defines joins across the following documented base objects:

  • PO_HEADERS_ALL (SYNONYM) — contract header attributes such as segment, currency, rate, vendor, and status flags.
  • PO_LINES_ALL (SYNONYM) — contract line attributes including item, category, unit price, and line-level flags.
  • PO_VENDORS (VIEW) and PO_VENDOR_SITES_ALL (VIEW) — supplier name, supplier ID, and supplier site details.
  • MTL_UNITS_OF_MEASURE_TL (SYNONYM) — translated unit-of-measure codes.
  • GL_CURRENCIES (SYNONYM) — currency precision and minimum accountable unit for functional price rounding.
  • FINANCIALS_SYSTEM_PARAMS_ALL (SYNONYM) — financials system parameters affecting price behavior.
  • FND_LANGUAGES (SYNONYM) — filters UOM translations to installed languages.
  • FND_GLOBAL (PACKAGE) — session context utilities referenced in the definition.

The view joins PO_HEADERS_ALL to PO_LINES_ALL on PO_HEADER_ID, and resolves supplier, UOM, and currency attributes through the remaining objects.

Key Columns

The view exposes contract identifiers and descriptive attributes, including CONTRACT_NUM (SEGMENT1), CONTRACT_LINE (LINE_NUM), CONTRACT_ID (PO_HEADER_ID), and CONTRACT_LINE_ID (PO_LINE_ID). Item and category information is available through ITEM_ID, ITEM_DESCRIPTION, CATEGORY_ID, and LINE_TYPE_ID. Pricing columns include CONTRACT_PRICE (PL.UNIT_PRICE), FUNCTIONAL_PRICE, UNIT_OF_MEASURE, CURRENCY, and CONTRACT_CURRENCY.

Regarding the searched term, CONTRACT_FROZEN_FLAG maps directly to PO_HEADERS_ALL.FROZEN_FLAG. When set, the contract is frozen and cannot be modified; when null, the contract remains open to change. Closely related columns include CONTRACT_APPROVED_FLAG, CONTRACT_CANCEL_FLAG, CONTRACT_CLOSED_CODE, CONTRACT_LINE_CLOSED_CODE, and CONTRACT_LINE_CANCEL_FLAG, which together describe the lifecycle state of the contract and its lines. Supplier columns include SUPPLIER, SUPPLIER_ID, SUPPLIER_SITE_ID, SUPPLIER_SITE_CODE, and SUPPLIER_PART_NUMBER.

Common Use Cases and Queries

Typical scenarios include identifying active, non-frozen contracts available for iProcurement sourcing, validating pricing and currency conversion, and auditing contract approval and closure status. A representative query filtering on the frozen flag follows:

  • SELECT CONTRACT_NUM, CONTRACT_LINE, SUPPLIER, CONTRACT_PRICE, CURRENCY, CONTRACT_START_DATE, CONTRACT_END_DATE FROM ICX_POR_EXT_CONTRACTS WHERE CONTRACT_FROZEN_FLAG IS NULL AND CONTRACT_CANCEL_FLAG = 'N' AND CONTRACT_CLOSED_CODE IS NULL;
  • Reporting by supplier: SELECT SUPPLIER, CONTRACT_NUM, CONTRACT_PRICE FROM ICX_POR_EXT_CONTRACTS WHERE SUPPLIER_ID = :vendor_id;
  • Auditing frozen contracts: SELECT CONTRACT_NUM, CONTRACT_FROZEN_FLAG, CONTRACT_APPROVED_FLAG FROM ICX_POR_EXT_CONTRACTS WHERE CONTRACT_FROZEN_FLAG = 'Y';

Because the view is a read-only projection, it should not be used for transactional updates. Access is typically granted through iProcurement responsibilities.