Results for “date_effective_to”

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

Overview

OKL_AM_RESTRUCTURE_QUOTES_UV is a consolidated, user-facing view owned by the APPS schema in Oracle Lease and Finance Management (OKL), part of the Oracle E-Business Suite 12.1.1 and 12.2.2 code lines. The view exposes restructure quote data captured on lease and finance contracts, presenting quotation attributes such as quote number, type, status, rent amount, term, yield, and restructure effective dates in a single denormalized result set. Its primary purpose is to serve inquiry screens, embedded analytics, and downstream reporting or integration extracts that require a pre-joined, code-decoded representation of restructure quotations rather than raw transactional storage.

The "_UV" suffix indicates a user-facing validation view, meaning the object is intended for consumption by forms, BI Publisher reports, and custom SQL rather than for direct DML. Because the view is documented as VALID in both 12.1.1 and 12.2.2, its definition has been stable across the release boundary, making it safe to reference in cross-release customization and extension code. The view is scoped in part through FND_GLOBAL, so multi-org security (ORG_ID) is available to callers.

The user search term consolidated_qte_id corresponds directly to a projected column in this view. This column associates a restructure quote with the consolidated quotation record that groups it with related quotes, enabling reporting on multi-quote restructure scenarios such as bundled lease modifications.

Underlying Base Objects

The view is defined over four documented referenced objects:

• OKL_TRX_QUOTES_V (VIEW) — the primary source, aliased OTQ, supplying quote-level attributes including ID, KHR_ID, QUOTE_NUMBER, QTP_CODE, QST_CODE, QRS_CODE, rent, term, yield, restructure dates, and the consolidated quote columns.
• OKC_K_HEADERS_ALL_B (SYNONYM) — the contract header, aliased OKF, joined on OTQ.KHR_ID = OKF.ID using an outer join (+) so quotes without a matched header are still returned. It supplies CONTRACT_NUMBER, START_DATE, and END_DATE.
• FND_LOOKUPS (VIEW) — referenced four times (FL1–FL4) to decode OKL_QUOTE_STATUS, OKL_QUOTE_TYPE, OKL_QUOTE_REASON, and OKL_YES_NO lookup codes into their MEANING values.
• FND_GLOBAL (PACKAGE) — used to resolve runtime context such as organization and user information.

The filter OTQ.QTP_CODE LIKE 'RES%' restricts the result set to restructure-type quotations, which is the defining characteristic of this view.

Key Columns

• ID — unique identifier of the restructure quote.
• KHR_ID — foreign key to the contract header (OKC_K_HEADERS_ALL_B.ID).
• QUOTE_NUMBER / QUOTE_TYPE / QUOTE_STATUS — human-readable quote identifiers and decoded lookup meanings.
• RENT_AMOUNT, TERM, YIELD — core financial terms of the restructure quotation.
• DATE_EFFECTIVE_FROM / DATE_EFFECTIVE_TO — validity window of the quote.
• ACCEPTED_YN, APPROVED_YN, ACCEPTED_YN_MEANING — acceptance and approval flags with decoded meaning.
• CONSOLIDATED_QTE_ID — identifier of the parent consolidated quote, the column matching the user's search.
• CONSOLIDATED_YN — indicates whether the quote is part of a consolidation.
• PURCHASE_AMOUNT, PURCHASE_FORMULA — purchase option details applicable to the restructure.
• DATE_RESTRUCTURE_START / DATE_RESTRUCTURE_END — effective period of the restructure.
• ORG_ID — operating unit context for multi-org reporting.

Common Use Cases and Queries

Typical use cases include restructure quote inquiries, consolidated-quote grouping analysis, and contract-level restructure reporting. A common query retrieves consolidated restructure quotes for a given contract:

• SELECT id, quote_number, consolidated_qte_id, consolidated_yn, rent_amount, contract_number FROM okl_am_restructure_quotes_uv WHERE consolidated_yn = 'Y' AND khr_id = :p_khr_id;
• SELECT consolidated_qte_id, COUNT(*) qte_count, SUM(rent_amount) total_rent FROM okl_am_restructure_quotes_uv WHERE org_id = :p_org_id GROUP BY consolidated_qte_id;
• SELECT quote_number, quote_status, quote_type, date_restructure_start, date_restructure_end FROM okl_am_restructure_quotes_uv WHERE accepted_yn = 'Y' AND approved_yn = 'Y';

Because the view resolves lookup meanings inline, reports can present QUOTE_TYPE, QUOTE_STATUS, and QUOTE_REASON directly without additional joins, simplifying SQL used in BI Publisher data models and concurrent program output.