Results for “lty_code”

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

Overview

OKL_SO_COVERED_ASSET_UV is an APPS-owned view in the OKL (Lease and Finance Management) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its name indicates its purpose: it exposes "covered assets" — leased assets — as they appear on the sales-order side of the ETRM (Enterprise Transaction and Relationship Management) data model shared with Oracle Contracts (OKC). The view is a UNION-friendly ("_UV") read-only object that surfaces a single asset line as it exists within a quote-stage contract.

The view is not a base table; it is a constrained projection over the OKC contract line and header tables, filtered to return a normalized row per covered asset. Because it joins the translated line table (OKC_K_LINES_TL) and applies USERENV('LANG'), it returns description data in the session's language.

Underlying Base Objects

The documented base objects are:

• OKC_K_HEADERS_B — the contract header, supplying contract identifier, status, authoring and inventory organization.
• OKC_K_LINES_B — the base contract line, driving line number, dates, and the line-style reference.
• OKC_K_LINES_TL — the translated line descriptions.
• OKC_LINE_STYLES_B — the line-style definition, the source of the LTY_CODE and LSE_TYPE columns.

All four are referenced as synonyms owned by APPS. The join path is TL.ID = FINA.ID linked to the base line, FINA.CHR_ID = CHR.ID to the header, and LS.ID = FINA.LSE_ID to the line style.

Key Columns

• NAME and DESCRIPTION — the asset's item name and description, taken from the translated line table.
• CHR_ID and DNZ_CHR_ID — the contract header identifier and its associated record reference.
• LTY_CODE and LSE_TYPE — the line-style code and the style's "lse_type" attribute, the field most commonly searched for. The view restricts rows to LTY_CODE = 'FREE_FORM1'.
• LINE_NUMBER, DATE_TERMINATED — the line's sequence and termination date, if any.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the line's effective date range.
• STATUS — a derived flag from SYSDATE: 'I' when outside the active range, 'A' when within it.
• CONTRACT_STATUS — the header's STS_CODE.
• ORG_ID and INV_ORG_ID — the authoring organization and inventory organization.
• PRIMARY_UOM_CODE — exposed as NULL; the view does not carry a primary unit of measure.

Common Use Cases and Queries

Because the view is filtered to the 'FREE_FORM1' line style and to headers with SCS_CODE = 'QUOTE', it is typically used to reconcile quoted lease assets against the order-side inventory of covered assets, or to validate the lse_type assigned to an asset line.

A simple list of assets with their style type:

• SELECT name, description, lty_code, lse_type FROM okl_so_covered_asset_uv;

Locate assets by lse_type for a given contract:

• SELECT chr_id, line_number, name, lse_type, start_date_active, end_date_active FROM okl_so_covered_asset_uv WHERE lse_type = :p_lse_type AND chr_id = :p_chr_id ORDER BY line_number;

Report currently active quoted assets:

• SELECT name, lse_type, status, contract_status FROM okl_so_covered_asset_uv WHERE status = 'A' AND contract_status = 'QUOTE';

These queries reflect the view's documented structure and the ETRM 12.2.2 metadata, and apply equally to 12.1.1 where the underlying OKC objects are present.