Results for “okl_ar_receipt_ref_vl”

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

Overview

The view OKL_AR_RECEIPT_REF_VL is a read-only validity (VL) view owned by the APPS schema within the Oracle Leasing and Finance Management (OKL) product family. In Oracle EBS 12.1.1 and 12.2.2, it exposes a consolidated, language-resolved projection of Accounts Receivable (AR) receipt references that are used by OKL to associate external AR cash receipts with lease and finance contracts. The internal primary key it surfaces is OKL_AR_RECEIPT_ID, which maps directly to the SOURCE_ID of the underlying header-extension record.

The view's principal role is to act as a reference and reporting bridge between the OKL contract repository and Oracle Receivables. Rather than querying the header-extension tables directly, reporting, extensions, and integration code can select from this view to obtain the identifier, the language context, and the current contract status of a given AR receipt reference. Because it is a VL view, it transparently joins the base (_B) and translation (_TL) objects and filters by the runtime language environment, delivering a single row per receipt reference.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• OKL_EXT_AR_HEADER_SOURCES_B — the base table holding header-extension source records for external AR data. The view restricts this set to rows where SOURCE_TABLE = 'AR_CASH_RECEIPTS', isolating the cash-receipt header sources from other extension source types.
• OKL_EXT_AR_HEADER_SOURCES_TL — the translation table supplying language-dependent and status attributes for each header extension. The join is performed on HEADER_EXTENSION_ID, matching the base record to its translated counterpart.

The documented view text defines the following join logic:

SELECT RXH.SOURCE_ID      AS OKL_AR_RECEIPT_ID,
       RXHL.LANGUAGE       AS OKL_LANGUAGE,
       RXHL.CONTRACT_STATUS AS OKL_CONTRACT_STATUS
FROM   OKL_EXT_AR_HEADER_SOURCES_B  RXH,
       OKL_EXT_AR_HEADER_SOURCES_TL RXHL
WHERE  RXH.SOURCE_TABLE = 'AR_CASH_RECEIPTS'
AND    RXH.HEADER_EXTENSION_ID = RXHL.HEADER_EXTENSION_ID

The cardinality is effectively one translated row per matching header extension. The SOURCE_TABLE filter ensures only AR cash receipt sources are surfaced, keeping the view purpose-built for the OKL-to-AR receipt relationship.

Key Columns

• OKL_AR_RECEIPT_ID — aliased from RXH.SOURCE_ID; the primary identifier representing the AR cash receipt reference within OKL. This is the column users typically search on and reference in downstream joins and APIs.
• OKL_LANGUAGE — aliased from RXHL.LANGUAGE; the language code of the translated row, governing which translation is returned in a multilingual environment.
• OKL_CONTRACT_STATUS — aliased from RXHL.CONTRACT_STATUS; the localized status of the contract associated with the receipt reference, used for status-driven filtering and reporting.

Common Use Cases and Queries

Typical applications include contract-to-receipt reconciliation reports, integration extracts that push receipt references into downstream systems, and validation queries confirming that an AR cash receipt has been correctly linked to leasing contract records. A representative lookup by identifier is:

SELECT okl_ar_receipt_id,
       okl_language,
       okl_contract_status
FROM   apps.okl_ar_receipt_ref_vl
WHERE  okl_ar_receipt_id = :p_receipt_id;

To list all references for a given contract status:

SELECT okl_ar_receipt_id,
       okl_contract_status
FROM   apps.okl_ar_receipt_ref_vl
WHERE  okl_contract_status = 'ACTIVE';

Because it is a VL view, results honor the session language, and any reporting layer built on it inherits correct translation behavior automatically. The view should be treated as read-only; underlying maintenance is performed against the _B and _TL tables through standard OKL APIs rather than direct DML.