Search Results ext_id

Overview

APPS.OKL_BPD_RECEIPT_ASSET_UV is a consolidated reporting view within the Oracle E-Business Suite (EBS) Enterprise Contracts / Lease Management (OKL) module, historically aligned with the former Enterprise Territory and Resource Management (ETRM) product family. The suffix "UV" denotes a user view intended primarily for reporting and integration consumption rather than transactional data entry. Its purpose is to reconcile cash receipt applications flowing through lease and contract streams against the fixed assets they finance or reference.

The view answers a specific business question: for a given receipt or consolidated cash application, which fixed asset in Oracle Assets (FA) is associated with it, and what amount was applied. This linkage is critical where leases fund capital acquisitions and the receipt application must be traceable to an asset record. In the context of the EBS 12.1.1 and 12.2.2 releases, this view operates against the same OKL/OKC/FA schema with the 12.2.2 Online Patching (Editioning) editioning views abstracting the underlying base tables.

Because the view joins subledger cash streams to asset additions and contract line styles, it serves both reconciliation reporting and downstream data extraction into asset-aware analytics.

Underlying Base Objects

The view is defined over a mix of views, synonyms, and package references documented in the ETRM 12.2.2 metadata:

• FA_ADDITIONS_V (view) — the Oracle Assets asset addition view supplying ASSET_ID, ASSET_NUMBER, SERIAL_NUMBER and description.
• OKL_XTL_CSH_APPS_B (synonym) — consolidated cash application detail lines, source of AMOUNT_APPLIED and XCR_ID_DETAILS.
• OKL_CNSLD_AR_STRMS_B (synonym) — consolidated AR stream header linking LSM_ID to stream/style.
• OKC_K_LINES_B and OKC_LINE_STYLES_B (synonyms) — contract lines and their line styles, used to filter LTY_CODE = 'FIXED_ASSET'.
• OKC_K_ITEMS (synonym) — contract line items where JTOT_OBJECT1_CODE = 'OKX_ASSET' maps OBJECT1_ID1 to the asset.
• OKL_STRM_TYPE_V (view) — stream type definitions providing STREAM_NAME and STREAM_TYPE_PURPOSE.
• FND_LOOKUPS (view) — lookup meanings for OKL_STREAM_TYPE_PURPOSE.
• FND_GLOBAL (package) and OKL_ACCOUNTING_UTIL (package) — referenced for session context and accounting logic.

The definition is a UNION ALL of three branches: asset-matched streams, orphan streams with no fixed-asset line style, and partial matches, ensuring no receipt amounts are silently dropped.

Key Columns

• EXT_ID — external identifier from XCR_ID_DETAILS, correlating to the cash receipt detail.
• ASSET_ID / ASSET_NUMBER / ASSET_NAME — asset identifiers; ASSET_NUMBER carries the FA serial number and ASSET_NAME the FA asset number. Values are NULL in the unmatched branch.
• ASSET_DESCRIPTION — descriptive text from FA_ADDITIONS_V.
• AMOUNT_APPLIED — summed application amount formatted as a character string ('99,999,999,999.99') via TO_CHAR.
• ASSET_STATUS — STS_CODE from the contract line, indicating line status.
• STREAM_NAME — the stream type name.
• MEANING — decoded lookup meaning for the stream type purpose.

Common Use Cases and Queries

Typical scenarios include asset-versus-receipt reconciliation, feeding asset-aware revenue schedules, and auditing receipts that reference fixed assets without a matching contract line.

SELECT asset_number, asset_name, ext_id, amount_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  asset_status = 'ACTIVE';

SELECT ext_id, SUM(TO_NUMBER(amount_applied)) total_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  asset_id IS NOT NULL
GROUP  BY ext_id;

Because AMOUNT_APPLIED is a formatted character value, arithmetic requires TO_NUMBER conversion. The unmatched branch (asset_id IS NULL) is useful for identifying receipts awaiting fixed-asset linkage.