Results for “okl_ext_ar_line_sources_v”

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

Overview

The OKL_EXT_AR_LINE_SOURCES_V view is an Oracle EBS Lease and Finance Management (OKL) reporting object owned by the APPS schema. It exposes lease contract line source information used in the integration between Oracle Lease Management (OLM) and Oracle Receivables (AR). The suffix _V denotes a translated view, meaning the base _B table stores the operational columns while the _TL table supplies language-dependent descriptive columns such as the transaction line description and stream type name. The view joins these two objects to present a single logical row per AR line source, keyed at the line level and linked to a parent header extension.

The view plays a role in reporting and integration scenarios where lease contract lines must be mapped to AR transactions, for example when deriving invoice lines, subsidies, fees, or memo lines. Because it exposes the HEADER_EXTENSION_ID and LINE_EXTENSION_ID, it is the natural access point for queries that need to trace an AR line back to its lease contract header extension.

Underlying Base Objects

The documented base objects are:

• OKL_EXT_AR_LINE_SOURCES_B (SYNONYM) — the base table holding the non-translated columns, including identifiers, descriptive flexfield attributes, and audit columns.
• OKL_EXT_AR_LINE_SOURCES_TL (SYNONYM) — the translation table holding language-specific descriptive columns, joined on the primary key and the current language.

The view text selects RXL columns from the base table and RXLL columns from the translation table, joining them on the line extension identifier and language. Only the _B table participates in the operational join; the _TL table augments each row with localized descriptions. The view is read-only and inherits the APPS schema privileges of its owner.

Key Columns

• LINE_EXTENSION_ID — the unique identifier of the AR line source record.
• HEADER_EXTENSION_ID — the parent header extension identifier, linking the line to its AR header context.
• SOURCE_ID, SOURCE_TABLE — identify the originating source record and table.
• KLE_ID, STY_ID — lease and stream type identifiers.
• ASSET_NUMBER, CONTRACT_LINE_NUMBER — lease contract line references.
• SUBSIDY_NAME, SUBSIDY_PARTY_NAME, FEE_TYPE_CODE, CONTINGENCY_CODE, MEMO_FLAG — AR line classification attributes.
• LINE_ATTRIBUTE_CATEGORY and LINE_ATTRIBUTE1..15 — descriptive flexfield segments.
• INVENTORY_ORG_CODE, INVENTORY_ORG_NAME, STREAM_TYPE_NAME, TRANS_LINE_DESCRIPTION — translation-supplied descriptive values.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — concurrency and audit columns.

Common Use Cases and Queries

Typical uses include validating AR line generation, reporting on lease contract line attributes, and troubleshooting header-to-line extension mappings. A query filtered by HEADER_EXTENSION_ID is common when investigating a specific AR header:

• Retrieve all lines for a header: SELECT line_extension_id, source_id, contract_line_number FROM okl_ext_ar_line_sources_v WHERE header_extension_id = :p_header_id;
• Report subsidy and fee detail by stream type: select stream_type_name, subsidy_name, and fee_type_code for a given contract line number.
• Expose descriptive flexfield values by querying line_attribute_category together with line_attribute1..15.

Because the view performs language translation, callers should set the session language appropriately to return the expected descriptive values.