Search Results okx_asset_lines_v




Overview
Explore in AI Chat

Overview

OKX_ASSET_LINES_V is a reporting and integration view owned by the APPS schema within the OKX – Contracts Integration product. It exposes the fixed asset lines associated with Oracle Contracts for Lease contracts. In the Oracle E-Business Suite lease management model, a lease contract can include asset lines that reference individual assets recorded in Oracle Fixed Assets. This view consolidates those relationships into a single denormalized structure, joining contract line information, line style attributes, lease header data, and fixed asset master details.

The view is documented as VALID and carries no transactional processing responsibility; it is a read-only construct intended for inquiry, reporting, and downstream integration. Because it joins across the OKC (Contracts Core), OKL (Lease Management), and FA (Fixed Assets) schemas, it is particularly valuable where lease contract asset detail must be reconciled with fixed asset inventory without navigating multiple application windows.

Underlying Base Objects

The view is defined over the following documented base objects, accessed through APPS synonyms:

The join path connects contract lines to lease headers and then to the fixed asset records surfaced through OKX_ASSETS_V, producing one row per fixed asset line.

Key Columns

Common Use Cases and Queries

Typical uses include lease-to-fixed-asset reconciliation, asset population reporting, and feeding downstream systems with asset-level lease detail.

SELECT line_number, name, asset_number, cost, status
FROM   apps.okx_asset_lines_v
WHERE  chr_id = :p_contract_id
ORDER BY line_number;
SELECT asset_number, original_cost, adjusted_cost, deprn_method_code
FROM   apps.okx_asset_lines_v
WHERE  status = 'A'
AND    org_id = :p_org_id;

The view is best queried with restrictive predicates on CHR_ID, ORG_ID, or ASSET_NUMBER, since it joins several high-volume contract and asset tables.