Results for “okl_am_restructure_lines_uv”

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

Overview

OKL_AM_RESTRUCTURE_LINES_UV is a consolidated reporting view owned by the APPS schema in Oracle Leasing and Finance Management (OKL), part of Oracle E-Business Suite 12.1.1 and 12.2.2. The view exposes restructure quote header and line information side by side in a single flattened result set, allowing restructuring activity on lease and finance contracts to be reported without joining the quote, contract header, and quote line entities manually.

The view is defined over quote data maintained by the Oracle Transactional RESTRUCTURE (ETRM) transaction model. Its defining filter restricts output to restructure quotes by requiring OTQ.QTP_CODE LIKE 'RES%'. As a result, only quote types whose code begins with "RES" — the restructure quote classification — appear in the result set. Each row represents one restructure quote line, with the parent quote attributes repeated on every line for the associated quote.

Underlying Base Objects

The documented base objects referenced by the view are:

• OKL_TRX_QUOTES_V (VIEW) — source of quote header attributes, aliased OTQ.
• OKL_TXL_QUOTE_LINES_V (VIEW) — source of quote line attributes, aliased QTL.
• OKC_K_HEADERS_B (SYNONYM) — contract header, aliased OKF, joined to the quote through OTQ.KHR_ID = OKF.ID using an outer join.
• FND_LOOKUPS (VIEW) — four separate instances (FL1 through FL4) resolve lookup meanings for quote status, quote type, quote reason, and quote line type.
• FND_GLOBAL (PACKAGE) — standard EBS session context package referenced by the underlying views.

The join OTQ.ID = QTL.QTE_ID links each quote header to its lines. The outer join to OKC_K_HEADERS_B means quotes without a matching contract header still return rows, with contract header columns null. Lookup joins are inner joins constrained by lookup type codes OKL_QUOTE_STATUS, OKL_QUOTE_TYPE, OKL_QUOTE_REASON, and OKL_QUOTE_LINE_TYPE.

Key Columns

The view projects both header-level and line-level attributes:

• QTE_ID, QUOTE_NUMBER, KHR_ID — identifier, user-visible number, and contract header reference for the quote.
• QTP_CODE / QUOTE_TYPE and QST_CODE / QUOTE_STATUS — coded and decoded quote type and status.
• DATE_EFFECTIVE_FROM, DATE_EFFECTIVE_TO, DATE_RESTRUCTURE_START, DATE_RESTRUCTURE_END — effective dating and the restructure window.
• ACCEPTED_YN, APPROVED_YN — approval and acceptance indicators.
• CONSOLIDATED_QTE_ID, CONSOLIDATED_YN — reference to a consolidated parent quote and the flag indicating whether the quote participates in consolidation. This is the column most commonly searched for under the term "consolidated_yn."
• LINE_START_DATE, PERIOD, NUMBER_OF_PERIODS, ADVANCE_OR_ARREARS, YIELD_NAME, YIELD_VALUE, IMPLICIT_INTEREST_RATE, AMOUNT, LINE_NUMBER, QLT_CODE / QUOTE_LINE_TYPE — payment stream and pricing attributes for each restructure line.

Common Use Cases and Queries

Typical uses include reconstructing restructure quote histories, auditing accepted or approved restructure quotes, isolating consolidated versus standalone restructure quotes, and feeding downstream reporting or integration extracts.

List restructure quotes with their contract numbers and status:

• SELECT qte_id, quote_number, quote_type, quote_status, contract_number FROM okl_am_restructure_lines_uv WHERE accepted_yn = 'Y';

Identify consolidated restructure quotes:

• SELECT DISTINCT qte_id, quote_number, consolidated_qte_id, consolidated_yn FROM okl_am_restructure_lines_uv WHERE consolidated_yn = 'Y';

Report restructure line payment streams for a given contract:

• SELECT quote_number, contract_number, line_number, line_start_date, period, number_of_periods, amount FROM okl_am_restructure_lines_uv WHERE contract_number = :contract_number ORDER BY line_number;