Search Results ib_line_id

Overview

APPS.OKL_AM_QTE_UNITS_UV is a reporting and integration view within the Oracle E-Business Suite (EBS) Enterprise Contract and Transaction Management (formerly OKL/OKC) module. Within the context of EBS 12.1.1 and 12.2.2, this view exposes Asset Management quote unit information by joining transaction quote lines to their associated contract line structures and installed asset instances. It presents a flattened, denormalized projection that combines quote header data, quote line quantities, contract delivery/finance line identifiers, and Customer Service (CSI) item instance details.

The view is read-only and is primarily intended for inquiry and downstream reporting rather than transactional update. It centralizes data that would otherwise require navigating several hierarchy levels of OKC contract lines (finance line, instance line, item line) and OKL transaction quote lines. Because it exposes the internally generated identifiers such as ib_line_id and fin_line_id, it is frequently used when diagnosing how an Asset Management quote line maps to the underlying contract and installed base records. The presence of the ARP_ADDR_LABEL_PKG reference indicates that address formatting logic is invoked to render installer/location information as a human-readable string.

Underlying Base Objects

The view is defined over a set of OKC contract tables, OKL transaction tables, CSI installed base tables, and HZ party/location tables, joined through their primary and foreign key relationships. The documented base objects are:

• OKL_TRX_QUOTES_B — the transaction quote header, providing quote_number and the quote identifier (qte_id).
• OKL_TXL_QTE_LINES_ALL_B — the quote line detail table, linked via the contract line identifier (kle_id) and filtered for quote line type code "AMCFIA".
• OKL_TXD_QUOTE_LINE_DTLS, OKL_TXL_QUOTE_LINES_B — additional quote line objects referenced within the OKL quote model.
• OKC_K_LINES_B and OKC_K_LINES_TL — the contract line base and translation tables, used multiple times (aliased CLE_FIN, CLE_INST, CLE_IB, CLET_FIN) to represent the finance, instance, and item line levels of the contract hierarchy.
• OKC_LINE_STYLES_B — the line style definitions, restricting to styles "FREE_FORM1", "FREE_FORM2", and "INST_ITEM".
• OKC_K_ITEMS — the contract item linkage, joined to the CSI instance.
• CSI_ITEM_INSTANCES — the installed base instance, supplying serial number, instance number, and quantity.
• HZ_LOCATIONS, HZ_PARTY_SITES, HZ_PARTY_SITE_USES — the location and party-site chain, filtered by site use type "INSTALL_AT".
• ARP_ADDR_LABEL_PKG — the packaged procedure used to format the concatenated location description.

Key Columns

• quote_number, qst_code, qtp_code, qte_id — quote header identifiers and type/status codes.
• tql_id — identifier of the transaction quote line.
• ib_line_id — the contract line identifier for the "installed base"/item line (alias CLE_IB), a key search target for users tracing asset quotes to contract structures.
• fin_line_id, dnz_chr_id — the finance-level contract line and its owning contract/document identifier.
• asset_quantity, quote_quantity, instance_quantity — quantities at the quote and instance level.
• serial_number, instance_number, asset_number, asset_description — installed asset identification and descriptive attributes.
• location_description — a formatted address string derived from the HZ location hierarchy.

Common Use Cases and Queries

A frequent scenario is identifying the contract item line associated with a given quote, particularly when resolving a user's search for ib_line_id. A typical query joins or filters on quote identifiers and returns the line mapping:

• Trace an asset quote to its contract line:

SELECT quote_number, qte_id, tql_id, ib_line_id, fin_line_id, dnz_chr_id, asset_number
FROM   apps.okl_am_qte_units_uv
WHERE  quote_number = :quote_number;

• Locate a record by ib_line_id:

SELECT quote_number, qte_id, tql_id, fin_line_id, serial_number, asset_number,
       instance_quantity, location_description
FROM   apps.okl_am_qte_units_uv
WHERE  ib_line_id = :ib_line_id;

• Report all quoted asset units for a contract document:

SELECT dnz_chr_id, fin_line_id, ib_line_id, asset_number, asset_description,
       asset_quantity, instance_quantity
FROM   apps.okl_am_qte_units_uv
WHERE  dnz_chr_id = :chr_id
ORDER  BY fin_line_id, ib_line_id;

These queries support reconciliation between the OKL quote model and the OKC contract/CSI installed base model, and are useful for audit, asset assignment verification, and integration extracts that must carry both the finance line and installed-base line identifiers.