Results for “okl_ap_ia_ref_v”

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

Overview

The OKL_AP_IA_REF_V view is an APPS-owned, VALID database view in the Oracle E-Business Suite Lease and Finance Management (OKL) module. It presents a consolidated, reporting-oriented projection of Investor Agreement (IA) related source data that flows into Oracle Payables transactions. Its central purpose is to expose the linkage between lease contract stream lines and the investor agreement header context under which those lines are processed for AP invoicing.

The view is specifically scoped to records where the header source indicator SCS_CODE equals 'INVESTOR', and where the corresponding line source table is OKL_TXL_AP_INV_LNS_B. In practice, this makes the view a targeted reference for lease contracts that are associated with investor agreements — a common requirement in lease securitization, syndication, and investor funding structures where invoicing must be attributed back to a specific investor pool, product, or currency.

Because it joins header-level investor agreement attributes with line-level stream classification, the view serves as a bridge between lease accounting stream definitions and the AP invoice generation framework. It is consumed by reporting, reconciliation, and downstream integration logic rather than by transactional entry.

Underlying Base Objects

The view is defined over two documented base objects, both exposed as synonyms within APPS:

• OKL_EXT_AP_HEADER_SOURCES_B (aliased PXH) — the AP header extension source table, supplying investor agreement header attributes and the header extension identifier.
• OKL_EXT_AP_LINE_SOURCES_B (aliased PXL) — the AP line extension source table, supplying stream type, stream purpose, source identifiers, and accounting template information.

The join is driven by PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID, with the constant constraint PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B' restricting the population to invoice line sources. The header is further filtered by SCS_CODE = 'INVESTOR'. This structure confirms the view is a denormalized read layer combining header and line source records for investor-scoped AP invoice references.

Key Columns

• OKL_TPL_ID — derived from PXL.SOURCE_ID; the source identifier for the underlying transaction line.
• OKL_PRODUCT_TABLE — a literal value, 'OKL_TXL_AP_INV_LNS_ALL_B', identifying the product table context.
• OKL_KHR_ID, OKL_KLE_ID, OKL_TRY_ID — contract, lease/line, and transaction identifiers linking the record back to the lease.
• TCL_STY_ID — derived from PXL.STY_ID; the stream type identifier.
• TCL_STREAM_TYPE_CODE — the stream type classification code.
• TCL_STREAM_TYPE_PURPOSE — derived from PXL.STREAM_TYPE_PURPOSE_CODE; the purpose classification of the stream. This column matched the user search term tcl_stream_type_purpose.
• Investor agreement attributes — TEH_INV_AGRMNT_NUMBER, TEH_INV_AGRMNT_EFFECTIVE_FROM, TEH_INV_AGRMNT_STATUS_CODE, TEH_INV_AGRMNT_CURRENCY_CODE, TEH_INV_AGRMNT_POOL_NUMBER, and TEH_INV_AGRMNT_SYND_CODE.
• TCN_INV_AGRMNT_PRODUCT_NAME — investor agreement product name.
• DIST_ACCOUNTING_TEMPLATE_NAME — the accounting template used for distribution.
• TEL_MEMO_FLAG — memo flag indicator.
• TEH_TRX_TYPE_CLASS_CODE — the transaction type class code.

Common Use Cases and Queries

Typical scenarios include reconciling investor agreement invoicing, verifying stream type and purpose classification for investor-funded lease lines, and driving downstream AP or reporting extracts. A representative query filtering on the stream purpose is:

• SELECT okl_kle_id, tcl_stream_type_code, tcl_stream_type_purpose, teh_inv_agrmnt_number, tcn_inv_agrmnt_product_name FROM apps.okl_ap_ia_ref_v WHERE tcl_stream_type_purpose = :purpose;
• SELECT tcl_stream_type_code, tcl_stream_type_purpose, COUNT(*) FROM apps.okl_ap_ia_ref_v GROUP BY tcl_stream_type_code, tcl_stream_type_purpose;
• SELECT okl_kle_id, teh_inv_agrmnt_number, teh_inv_agrmnt_currency_code, dist_accounting_template_name FROM apps.okl_ap_ia_ref_v WHERE teh_inv_agrmnt_status_code = :status;

These queries support audit, reconciliation, and investor reporting requirements across lease contracts processed through Payables.