Results for “ext_id”

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

Overview

OKL_BPD_RECEIPT_ASSET_UV is an APPS-owned database view within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It exposes a consolidated, asset-centric read model that links lease receipts, applied cash transaction lines, contract line items, and fixed asset records. Its name — "BPD Receipt Asset User View" — indicates it is a user-facing (non-API) view designed for Business Process Delivery of receipt-to-asset reconciliation and reporting.

The view's principal role is to answer the recurring business question in leasing operations: which fixed assets are associated with which receipt applications, under which stream, and at what applied amount. By joining accounting stream data to FA_ADDITIONS_V, it bridges OKL's consolidated receivables and stream architecture with Oracle Assets, allowing accounts receivable and leasing administrators to trace cash application results directly to capitalized or leased assets. The view is status VALID in the APPS schema under Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a union of select statements drawing from the following documented base objects:

• OKL_XTL_CSH_APPS_B — the applied cash transaction lines supplying AMOUNT_APPLIED and XCR_ID_DETAILS (receipt identifier).
• OKL_CNSLD_AR_STRMS_B — the consolidated AR stream header, joined via LSM_ID to the transaction lines.
• OKL_STRM_TYPE_V — the stream type view providing the stream NAME and STREAM_TYPE_PURPOSE.
• OKC_K_LINES_B and OKC_LINE_STYLES_B — contract lines and their styles; the filter LTY_CODE = 'FIXED_ASSET' restricts results to fixed-asset contract lines.
• OKC_K_ITEMS — contract line items, filtered to JTOT_OBJECT1_CODE = 'OKX_ASSET', linking to asset identity.
• FA_ADDITIONS_V — the Oracle Assets additions view supplying ASSET_ID, ASSET_NUMBER, SERIAL_NUMBER, and DESCRIPTION.
• FND_LOOKUPS — supplies the lookup MEANING for lookup type 'OKL_STREAM_TYPE_PURPOSE'.
• FND_GLOBAL and OKL_ACCOUNTING_UTIL — referenced utility objects supporting session context and accounting logic.

The UNION ALL construct ensures assets tied to fixed-asset contract lines are reported alongside stream-level receipt applications that have no qualifying fixed-asset line, preserving a complete receipt picture.

Key Columns

• EXT_ID (XCR_ID_DETAILS) — external receipt identifier linking the application back to the originating cash receipt.
• ASSET_ID — the FA asset identifier from FA_ADDITIONS_V; null in the stream-only union branch.
• ASSET_NUMBER — the asset serial number.
• ASSET_NAME — derived from FA.ASSET_NUMBER, used as a display name.
• ASSET_DESCRIPTION — the asset description from Oracle Assets.
• AMOUNT_APPLIED — the summed applied receipt amount, formatted with a numeric mask.
• ASSET_STATUS (STS_CODE) — the contract line status code.
• STREAM_NAME — the stream name from OKL_STRM_TYPE_V.
• MEANING — the decoded stream type purpose from FND_LOOKUPS.

Common Use Cases and Queries

The view supports receipt-to-asset reconciliation, stream reporting, and fixed-asset financial analysis.

List assets with applied receipt amounts:

SELECT asset_number, asset_description, stream_name, amount_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  asset_id IS NOT NULL;

Summarize applied amounts by stream purpose:

SELECT meaning, SUM(TO_NUMBER(amount_applied)) total_applied
FROM   apps.okl_bpd_receipt_asset_uv
GROUP  BY meaning;

Trace a specific receipt to its asset:

SELECT ext_id, asset_number, amount_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  ext_id = :receipt_id;

Because FA_ADDITIONS_V and FND_LOOKUPS are operational views, report performance should be considered on large data sets; restricting by EXT_ID or stream is advisable in production queries.