Results for “early_termination_yn”

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

Overview

OKL_TRX_QUOTES_ALL_B is the core transaction table in the Oracle E-Business Suite OKL — Leasing and Finance Management product that stores termination, restructure, and repurchase quotes generated against lease and finance contracts. The table resides in the OKL schema and is registered as VALID in both 12.1.1 and 12.2.2. It acts as the header-level repository for every quotation lifecycle in ETRM: quote request, proposal, approval, acceptance, and payment receipt.

Under a heuristic Data Vault classification mined from its foreign-key topology, the table behaves as a hub. The classification is a modeling suggestion: the table holds a small number of descriptive business keys (notably QUOTE_NUMBER) and serves as the anchor from which downstream satellite-style tables — invoices, contract records, termination interface rows, and quote parties — hang. The presence of audit columns (CREATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER) confirms it is a transactional header table rather than a pure reference object.

Key Information Stored

The surrogate primary key is ID, enforced by OKL_TRX_QUOTES_ALL_B_PK. The business-key candidate is QUOTE_NUMBER, enforced by the unique index OKL_TRX_QUOTES_ALL_B_U1 (also referenced as UK1). Among the 81 documented columns, the most operationally significant are:

• QUOTE_NUMBER — user-visible identifier for the quote; the principal business key.
• QRS_CODE / QST_CODE / QTP_CODE / TRN_CODE — quote reason, status, type, and transaction classification codes.
• KHR_ID — foreign key to OKL_K_HEADERS, linking the quote to its originating contract header.
• PDT_ID — foreign key to OKL_PRODUCTS, identifying the financing product.
• CONSOLIDATED_QTE_ID — self-referencing foreign key that ties a child quote to its consolidated parent.
• ART_ID — self-referencing association to a related artifact row.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, establishing the transacting legal entity.
• DATE_REQUESTED, DATE_PROPOSAL, DATE_APPROVED, DATE_ACCEPTED, DATE_EFFECTIVE_FROM, DATE_EFFECTIVE_TO — the quotation lifecycle timestamps.
• REMAINING_PAYMENTS, RENT_AMOUNT, RESIDUAL_AMOUNT, PRINCIPAL_PAYDOWN_AMOUNT, PURCHASE_AMOUNT — monetary drivers for the quote calculation.
• APPROVED_YN, ACCEPTED_YN, PAYMENT_RECEIVED_YN, CONSOLIDATED_YN — status flags controlling workflow progression.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — multicurrency revaluation context.
• ORG_ID — operating unit partition used for multi-org security.

Common Use Cases and Queries

ETRM users query this table to retrieve outstanding termination or restructure proposals, drive approval workflows, and reconcile accepted quotes against generated receivables or payables. Typical reporting includes quote pipeline analysis by status and product, residual versus purchase-amount comparison, and consolidated quote roll-ups.

A representative query retrieving open quotes for a contract:

• SELECT q.QUOTE_NUMBER, q.QST_CODE, q.DATE_PROPOSAL, q.RENT_AMOUNT, q.RESIDUAL_AMOUNT FROM OKL_TRX_QUOTES_ALL_B q, OKL_K_HEADERS h WHERE q.KHR_ID = h.ID AND q.APPROVED_YN = 'N' AND q.ORG_ID = :org_id;

Consolidated quote hierarchies are recovered via the self-referencing key:

• SELECT child.QUOTE_NUMBER, parent.QUOTE_NUMBER FROM OKL_TRX_QUOTES_ALL_B child, OKL_TRX_QUOTES_ALL_B parent WHERE child.CONSOLIDATED_QTE_ID = parent.ID;

Related Objects

OKL_TRX_QUOTES_ALL_B is heavily referenced. The principal dependent and related objects, with their documented join columns, are:

• OKL_K_HEADERS — contract header master; joined via OKL_TRX_QUOTES_ALL_B.KHR_ID = OKL_K_HEADERS.ID.
• OKL_PRODUCTS — product definition; joined via PDT_ID = OKL_PRODUCTS.PDT_ID.
• FV_LEGAL_ENTITIES — legal entity master; joined via LEGAL_ENTITY_ID.
• OKL_TRX_CONTRACTS_ALL — resulting contracts; references QTE_ID back to this table.
• OKL_TRX_AR_INVOICES_B and OKL_TRX_AP_INVS_ALL_B — receivables and payables generated from accepted quotes (QTE_ID).
• OKL_TERMNT_INTERFACE_ALL — termination interface staging rows linked by QTE_ID.
• OKL_TRX_QTE_CF_OBJECTS — quote cash-flow objects keyed by QTE_ID.
• OKL_QUOTE_PARTIES — parties associated with the quote, keyed by QTE_ID.
• OKL_TRX_QUOTES_ALL_B (self) — consolidation hierarchy through CONSOLIDATED_QTE_ID.