Results for “okl_kle_id”

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

Overview

The OKL_AR_ADJ_IA_REF_V view is an Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the OKL – Lease and Finance Management product. Its status is VALID. The view serves as a reference layer that exposes accounts receivable adjustment data specifically in the context of investor billing. As documented, the view is deliberately restricted to investor-source records, as indicated by the inline comment accompanying its definition: the reference view is only for investor billing. Consequently, records originated through the INVESTOR source code are the sole population returned when the view is queried.

Practically, the view joins adjustment line data to the header and line source tables that carry investor agreement attributes. This makes it a convenient reporting and integration access point for developers and analysts who need to correlate Receivables adjustments with lease investment agreement details without constructing the multi-table join manually.

Underlying Base Objects

The view is defined over three referenced base objects, all exposed through synonyms within the APPS schema:

• OKL_TXL_ADJSTS_LNS_ALL_B – the adjustment lines base table, aliased as AJL. This supplies the Receivables adjustment identifier and the internal adjustment line identifier.
• OKL_EXT_AR_HEADER_SOURCES_B – the external AR header source table, aliased as RXH. This provides investor agreement header attributes.
• OKL_EXT_AR_LINE_SOURCES_B – the external AR line source table, aliased as RXL. This supplies accounting template, contingency, memo flag, and stream type attributes.

The join predicates link the line source record to the adjustment line via RXL.SOURCE_ID = AJL.ID, and link the line source to the header source via RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID. Two static filters complete the definition: RXL.SOURCE_TABLE = 'OKL_TXL_ADJSTS_LNS_B' and RXH.SCS_CODE = 'INVESTOR'.

Key Columns

The most significant column for users arriving via a search on receivables_adjustment_id is RECEIVABLES_ADJUSTMENT_ID, which is sourced directly from AJL.RECEIVABLES_ADJUSTMENT_ID and acts as the primary linkage to Receivables adjustments. Closely related is OKL_AJL_ID, the internal adjustment line identifier (AJL.ID).

• OKL_KHR_ID, OKL_KLE_ID, OKL_TRY_ID, OKL_STY_ID – lease and header/line identifier keys.
• OKL_INV_AGRMNT_NUMBER, OKL_INV_AGRMNT_EFFECTIVE_FROM, OKL_INV_AGRMNT_PRODUCT_NAME – investor agreement descriptive attributes.
• OKL_INV_AGRMNT_CURRENCY_CODE, OKL_INV_AGRMNT_SYND_CODE, OKL_INV_AGRMNT_POOL_NUMBER, OKL_INV_AGRMNT_STATUS_CODE – agreement currency, syndication, pool, and status details.
• OKL_TRX_TYPE_CLASS_CODE, OKL_AE_TEMPLATE_NAME, OKL_CONTINGENCY_CODE – transaction classification and accounting template information.
• OKL_MEMO_FLAG, OKL_STREAM_TYPE_CODE, OKL_STREAM_TYPE_PURPOSE_CODE – memo and cash stream characterization.

Note that the documented column listing includes a small number of naming variations, such as TCL_STY_ID and TEL_MEMO_FLAG, reflecting legacy naming retained in the view metadata.

Common Use Cases and Queries

Typical use cases include reconciling Receivables adjustments against investor lease agreements, extracting investor billing data for reporting, and validating adjustment-to-agreement linkage during integration or conversion work. The following query retrieves adjustment records for a specific Receivables adjustment identifier:

• SELECT receivables_adjustment_id, okl_inv_agrmnt_number, okl_inv_agrmnt_status_code, okl_trx_type_class_code FROM okl_ar_adj_ia_ref_v WHERE receivables_adjustment_id = :p_adj_id;
• SELECT receivables_adjustment_id, okl_ajl_id, okl_inv_agrmnt_currency_code FROM okl_ar_adj_ia_ref_v WHERE okl_inv_agrmnt_number = :p_agreement;

Because the view is filtered to INVESTOR source records, queries return only investor billing adjustments; other adjustment sources are intentionally excluded.