Results for “principal_paydown_amount”

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

Overview

OKL_TRX_QUOTES_ALL_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite (EBS) release 12.1.1 and 12.2.2. It is delivered as part of the OKL — Leasing and Finance Management product family. As its name and documentation indicate, the view is an "All Org" presentation of termination, restructure, and repurchase quotes. The "_ALL_V" suffix signifies that the view consolidates data across multiple operating units (organizations) rather than restricting results to a single org context, which makes it suitable for cross-organizational inquiry, concurrent reporting, and downstream integration.

In the ETRM object registry the view carries a status of VALID. Its purpose is to expose the full set of quote header attributes required by quote processing — including requested, proposal, acceptance, effective, and payment-related dates — so that both standard Oracle forms and customer-built reports can retrieve quote information without joining the underlying base tables directly.

Underlying Base Objects

The documented view metadata identifies two referenced base objects: the synonym OKL_TRX_QUOTES_ALL_B and the synonym OKL_TRX_QUOTES_TL. The "_B" table is the base (transaction) table holding the quote header records, including all business columns, date fields, and the descriptive flexfield attribute columns. The "_TL" table is the translatable table that stores language-dependent text such as comments. Because OKL_TRX_QUOTES_TL is a translation table, the view joins the base and translation rows to present a single, language-appropriate quote record combining structural data with descriptive text.

The view text selects primary key and row identification columns (ROW_ID from the base ROWID, ID, and OBJECT_VERSION_NUMBER) directly from the base alias QTEB, while comment text is drawn from the translation alias QTET. This join pattern is consistent with standard EBS multi-language view definitions.

Key Columns

• ID, ROW_ID, OBJECT_VERSION_NUMBER — primary identifier, physical row locator, and optimistic locking version.
• QUOTE_NUMBER — the user-facing quote reference number.
• DATE_REQUESTED, DATE_PROPOSAL, DATE_ACCEPTED, DATE_DUE, DATE_PAYMENT_RECEIVED — lifecycle dates for the quote. DATE_PROPOSAL is the date the quote proposal is issued to the customer.
• DATE_EFFECTIVE_FROM, DATE_EFFECTIVE_TO — validity window of the quote.
• DATE_RESTRUCTURE_START, DATE_RESTRUCTURE_END — restructure period boundaries.
• EARLY_TERMINATION_YN, PARTIAL_YN, PREPROCEEDS_YN — flags indicating quote type and characteristics.
• YIELD, RENT_AMOUNT, RESIDUAL_AMOUNT, PRINCIPAL_PAYDOWN_AMOUNT, PURCHASE_PERCENT, TERM, PAYMENT_FREQUENCY, REMAINING_PAYMENTS — financial and term attributes.
• REQUESTED_BY, APPROVED_YN, ACCEPTED_YN, PAYMENT_RECEIVED_YN — workflow and status indicators.
• ATTRIBUTE1–ATTRIBUTE10, ATTRIBUTE_CATEGORY — descriptive flexfield columns.
• COMMENTS — descriptive text sourced from the translation table.

Common Use Cases and Queries

The view is typically queried to list quotes by date criteria, quote type, or status. A typical query filtering on the proposal date follows:

SELECT quote_number, date_requested, date_proposal, date_accepted,
  yield, rent_amount, approved_yn, accepted_yn
FROM  apps.okl_trx_quotes_all_v
WHERE  date_proposal >= :p_from_date
AND    approved_yn = 'Y';

Because it is an all-org view, no operating unit filter is required by default. Reporting scenarios include quote aging by DATE_PROPOSAL, approval tracking, and extraction of quote financials for reconciliation. Care should be taken to filter on indexed columns where possible to keep performance acceptable on large quote populations.