Search Results fin_line_id

Overview

The view APPS.OKL_AM_QTE_UNITS_UV is a reporting and integration construct within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its documented description is "Quote unit details view," and it is exposed under the APPS schema with a status of VALID. The view consolidates quote-level, line-level, and asset-instance-level information into a single denormalized row set, allowing callers to retrieve the units associated with a lease or finance quote alongside their physical asset attributes and install location. Because the view joins transaction quote lines to Oracle Contracts (OKC) line structures and to CSI item instances, it serves as a bridge between the quoting stage and the asset instance stage of the lease lifecycle.

In both EBS 12.1.1 and 12.2.2 the object is delivered as a standard APPS view. It is commonly consumed by concurrent programs, OAF-based quote pages, and custom extensions that need to report quoted assets without navigating the full OKC/OKL entity model. The presence of the column ASSET_QUANTITY is significant for users searching on that term: the view surfaces the quantity of assets recorded against the quote line, distinguishing it from the separately exposed QUOTE_QUANTITY and CSI INSTANCE_QUANTITY.

Underlying Base Objects

The view is defined over a set of synonyms resolving to base tables and one package. The documented referenced objects are: OKL_TRX_QUOTES_B (the quote header), OKL_TXL_QTE_LINES_ALL_B (quote lines), OKL_TXL_QUOTE_LINES_B and OKL_TXD_QUOTE_LINE_DTLS (quote line detail structures), the OKC contract tables OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_ITEMS, and OKC_LINE_STYLES_B, the CSI table CSI_ITEM_INSTANCES, the party/location tables HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES, and the package ARP_ADDR_LABEL_PKG (used to format the location description).

Navigation proceeds from the quote header (OKL_TRX_QUOTES_B) into the line table (OKL_TXL_QTE_LINES_ALL_B, aliased TQL) through the contract line CLE_FIN. The view filters on line styles FREE_FORM1 (finance line), FREE_FORM2 (instance line), and INST_ITEM (instance item), and restricts to quote line type QLT_CODE = 'AMCFIA'. The CSI instance is reached via OKC_K_ITEMS using the object code OKX_IB_ITEM.

Key Columns

• QUOTE_NUMBER, QST_CODE, QTP_CODE, QTE_ID — quote header identifiers and type/status codes.
• TQL_ID — identifier of the quote line; TQD_ID is returned as a NULL placeholder.
• ASSET_QUANTITY — quantity of assets attributed to the quote line, the column most relevant to "asset_quantity" searches.
• QUOTE_QUANTITY — quantity expressed at the quote level.
• INSTANCE_QUANTITY, INSTANCE_NUMBER, SERIAL_NUMBER — physical instance attributes from CSI.
• IB_LINE_ID, FIN_LINE_ID, DNZ_CHR_ID — contract line and contract header keys linking to OKC.
• ASSET_NUMBER, ASSET_DESCRIPTION — descriptive asset fields from the finance contract line.
• LOCATION_DESCRIPTION — a formatted address string produced via ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS.

Common Use Cases and Queries

Typical usage includes reporting quoted assets by quote number, reconciling quote quantities against linked CSI instances, and exposing quote unit detail to downstream pricing or booking processes.

SELECT quote_number, tql_id, asset_quantity, quote_quantity,
       instance_number, serial_number, asset_number, location_description
FROM   okl_am_qte_units_uv
WHERE  quote_number = :p_quote_number;

To aggregate asset quantities across quotes:

SELECT quote_number, SUM(asset_quantity) total_asset_qty
FROM   okl_am_qte_units_uv
GROUP  BY quote_number;

To locate a unit by serial number and return its quote context:

SELECT quote_number, asset_number, asset_description, location_description
FROM   okl_am_qte_units_uv
WHERE  serial_number = :p_serial;