Results for “teh_inv_agrmnt_pool_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_AP_PAYMENTS_IA_REF_V is a reporting view owned by the APPS schema in Oracle Lease and Finance Management (OKL), part of the Oracle E-Business Suite releases 12.1.1 and 12.2.2. The view consolidates Accounts Payable (AP) invoice distribution lines with the investor agreement attributes carried on lease extension headers and lines, so that AP payments tied to investor agreements can be analyzed or interfaced without joining the individual source tables manually.

The name itself indicates its purpose: "AP_PAYMENTS" for the AP invoice distribution/payment flow, and "IA_REF" for the investor agreement reference carried through the extension tables. It is a read-only query construct rather than a table; it holds no data and is populated at run time from its base objects. In the ETRM context it supports the investor agreement reporting and integration flows in Lease and Finance Management, where invoice distributions originating from lease and terminal transactions must be traced to the governing investor agreement. The user search term "tcn_inv_agrmnt_product_name" corresponds directly to one of its derived columns, TCN_INV_AGRMNT_PRODUCT_NAME, which is the column many reporting queries and downstream extracts reference.

Underlying Base Objects

The view is defined over five documented base objects, all referenced as APPS synonyms:

• AP_INVOICE_DISTRIBUTIONS_ALL — supplies the invoice distribution identifier (INVOICE_DISTRIBUTION_ID) and links to the invoice line.
• AP_INVOICE_LINES_ALL — joined to the distribution on INVOICE_ID and LINE_NUMBER, and constrained to APPLICATION_ID = 540 and PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B'.
• OKL_TXL_AP_INV_LNS_ALL_B — the OKL invoice line extension table, matched through AIL.REFERENCE_KEY1 = TAL.ID.
• OKL_EXT_AP_HEADER_SOURCES_B — the header extension source, restricted to SCS_CODE = 'INVESTOR' and joined to the line extension on HEADER_EXTENSION_ID.
• OKL_EXT_AP_LINE_SOURCES_B — the line extension source, restricted to SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B' and joined on SOURCE_ID = TAL.ID.

Because the joins are anchored on the AP invoice distribution and line tables, the view preserves one row per distribution that satisfies the OKL/investor linkage. The presence of the SCS_CODE = 'INVESTOR' predicate means only investor-related extension records qualify; other source categories are excluded.

Key Columns

The view exposes the following columns, with their OKL aliases:

• OKL_INVOICE_DISTRIBUTION_ID — from AID.INVOICE_DISTRIBUTION_ID; the AP distribution key, useful for driving drill-downs to AP.
• OKL_KHR_ID — from PXH.KHR_ID; the key header reference for the investor agreement source.
• TEH_INV_AGRMNT_NUMBER, TEH_INV_AGRMNT_EFFECTIVE_FROM, TEH_INV_AGRMNT_STATUS_CODE — investor agreement number, effective date, and status.
• TCN_INV_AGRMNT_PRODUCT_NAME — from PXH.INV_AGRMNT_PRODUCT_NAME; the investor agreement product name, the column most frequently searched for in reporting.
• TEH_INV_AGRMNT_CURRENCY_CODE, TEH_INV_AGRMNT_POOL_NUMBER, TEH_INV_AGRMNT_SYND_CODE — currency, pool number, and syndication code of the agreement.
• TCL_STREAM_TYPE_CODE, TCL_STREAM_TYPE_PURPOSE — stream type and purpose from the line source.
• DIST_ACCOUNTING_TEMPLATE_NAME — accounting template applied to the line.
• TEL_MEMO_FLAG — memo flag on the line source.
• TEH_TRX_TYPE_CLASS_CODE — transaction type class of the header.

Common Use Cases and Queries

Typical uses include reconciling AP distributions back to investor agreements, building investor reporting extracts, and troubleshooting why a distribution appears under a particular agreement and product name.

• Filter by product name: SELECT okl_invoice_distribution_id, teh_inv_agrmnt_number, tcn_inv_agrmnt_product_name FROM okl_ap_payments_ia_ref_v WHERE tcn_inv_agrmnt_product_name = :product_name;
• List all distributions for an investor agreement: SELECT * FROM okl_ap_payments_ia_ref_v WHERE teh_inv_agrmnt_number = :agreement_number;
• Join to AP for invoice detail: SELECT v.tcn_inv_agrmnt_product_name, d.invoice_id, d.amount FROM okl_ap_payments_ia_ref_v v, ap_invoice_distributions_all d WHERE v.okl_invoice_distribution_id = d.invoice_distribution_id;

Queries against this view should be tuned on the distribution and extension key columns, since the definition performs several joins across the AP and OKL extension tables in a single pass.