Search Results icx_ap_checks_v




Overview
Explore in AI Chat

Overview

ICX_AP_CHECKS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the ICX (Oracle iProcurement) product family and documented in ETRM as the Supplier Payments View. It exposes payment check information originating from Oracle Payables in a denormalized, presentation-ready form so that iProcurement and related self-service pages can display supplier payment details to end users without querying the underlying transactional tables directly. The view is marked VALID in the ETRM registry for both 12.1.1 and 12.2.2.

The view is defined over AP_CHECKS (accessed through a synonym) and calls two program units: the FND_CURRENCY package for amount formatting and the ICX_AP_CHECKS_PKG package for invoice aggregation. Because it is a view rather than a table, it carries no independent storage and reflects the current state of the source records at query time.

Underlying Base Objects

The ETRM metadata documents three referenced objects:

  • AP_CHECKS (SYNONYM) — the primary source, supplied through the AP_CHECKS alias AC. All payment attributes (amount, check number, dates, vendor, address, status flags) are projected from this table.
  • FND_CURRENCY (PACKAGE) — invoked as FND_CURRENCY.SAFE_GET_FORMAT_MASK to derive the display format mask for the payment amount based on its currency code.
  • ICX_AP_CHECKS_PKG (PACKAGE) — invoked as ICX_AP_CHECKS_PKG.GET_INVOICES_PAID, returning the invoices settled by each check.

The view therefore acts as a lightweight presentation layer: it does not join multiple payment tables, but enriches a single AP_CHECKS row with currency formatting and a packaged invoice lookup.

Key Columns

The view exposes 31 columns. Principal groupings are:

The ADDRESS_STYLE column is significant because it signals the address layout convention to be applied when rendering the ADDRESS_LINE fields, enabling the UI to honor country-specific formatting.

Common Use Cases and Queries

Typical usage includes supplier payment inquiry pages in iProcurement, reconciliation reports, and check-register extracts. A basic query lists payments with status and formatted amount:

  • SELECT check_number, check_date, amount, currency_code, cleared, voided, stopped FROM apps.icx_ap_checks_v WHERE vendor_id = :p_vendor_id ORDER BY check_date DESC;

To render addresses respecting style, select the address components together:

  • SELECT check_number, vendor_site_code, address_style, address_line1, address_line2, address_line3, address_line4, city, state, zip, country FROM apps.icx_ap_checks_v WHERE check_id = :p_check_id;

For a reconciliation view of settled invoices, join or filter on the packaged INVOICES column:

  • SELECT check_number, invoices, future_pay_due_date FROM apps.icx_ap_checks_v WHERE cleared_date IS NOT NULL;

Consumers should apply the appropriate operating unit or security predicates used elsewhere in iProcurement, as the view itself imposes no row-level filtering.