Search Results invoice_amount_currency_code

Overview

The view AP_INVOICE_PAYMENTS_WWW_V is a Payables (AP) reporting object that joins invoice, payment, and payment-check information into a single denormalized result set. Its name and metadata indicate it was constructed to support a web-facing or self-service presentation layer, combining invoice header attributes with the disbursement details recorded against each invoice. The description explicitly notes "(Release 10SC Only)," and the ETRM record further states "Not implemented in this database." This means the view is a legacy artifact: it was defined in early Oracle Applications releases associated with the 10SC (self-service/Web) code line and is not shipped or created in Oracle EBS 12.1.1 or 12.2.2 environments.

Because the object is not implemented in current releases, it cannot be queried directly in 12.1.1 or 12.2.2. Its value is therefore chiefly documentary and diagnostic. It illustrates how Oracle historically exposed invoice-to-payment relationships to web pages, and it serves as a reference model for reconstructing equivalent reporting logic against the current base tables AP_INVOICES, AP_INVOICE_PAYMENTS, and AP_CHECKS. The user search term "discount_taken" maps directly to the view's DISCOUNT_TAKEN column, one of its most business-relevant outputs, reflecting the early-payment or negotiated discount captured when an invoice is settled.

Underlying Base Objects

The view text is defined over three Payables base tables joined on their primary keys:

• AP_INVOICE_PAYMENTS AIP — the payment detail (distribution of a payment across invoices), joined via AIP.INVOICE_ID and AIP.CHECK_ID.
• AP_INVOICES AI — the invoice header, joined via AIP.INVOICE_ID = AI.INVOICE_ID.
• AP_CHECKS AC — the payment document, joined via AIP.CHECK_ID = AC.CHECK_ID.

The ETRM metadata lists "Referenced base objects: none documented" for 12.2.2, consistent with the view not existing there. The SQL embedded in the historical view text nevertheless names the three tables above as its sources, and the join path confirms the logical grain: one row per invoice-payment intersection, enriched with invoice and check attributes. In current releases, equivalent data is obtained by querying AP_INVOICE_PAYMENTS directly and joining to AP_INVOICES and AP_CHECKS, since the WWW view is absent.

Key Columns

• DISCOUNT_TAKEN — expressed as NVL(AIP.DISCOUNT_TAKEN, 0); the discount amount applied to the invoice when the payment was made. This is the column most relevant to the user's search, and it is a core measure in payment-performance analysis.
• AMOUNT and AMOUNT_CURRENCY_CODE — the payment amount applied to the invoice, concatenated with the check currency for display.
• INVOICE_NUM / INVOICE_ID / INVOICE_CURRENCY_CODE — invoice identifiers and the invoice's transaction currency.
• INVOICE_AMOUNT_CURRENCY_CODE — a formatted string combining the invoice amount and its currency.
• CHECK_NUMBER / CHECK_ID / CHECK_CURRENCY_CODE — payment document identifiers and the payment currency.
• VENDOR_ID / VENDOR_SITE_ID — supplier and supplier site identifiers.
• ACCOUNTING_DATE — the accounting date of the payment, used for period and aging analysis.

Common Use Cases and Queries

Historically the view supported web pages displaying, for a given invoice or supplier, the payments applied and any discount captured. In Oracle EBS 12.1.1 and 12.2.2 the view does not exist, so the same result must be built from base tables. A representative reconstruction is:

• Discounts taken by supplier — sum DISCOUNT_TAKEN grouped by vendor to measure early-payment savings.
• Payment-to-invoice reconciliation — list invoices with their check numbers and accounting dates.
• Currency variance checks — compare invoice currency with check currency where cross-currency settlement occurs.

Equivalent SQL in 12.1.1/12.2.2:

• SELECT ai.invoice_num, ac.check_number, aip.amount, NVL(aip.discount_taken,0) discount_taken, aip.accounting_date FROM ap_invoice_payments aip, ap_invoices ai, ap_checks ac WHERE aip.invoice_id = ai.invoice_id AND aip.check_id = ac.check_id;

This query reproduces the legacy view's projection and confirms that the underlying columns, including DISCOUNT_TAKEN, remain available and authoritative in current releases.