Results for “okl_trx_qte_cf_objects”

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

Overview

OKL_TRX_QTE_CF_OBJECTS is a transaction-level table within the Oracle Lease and Finance Management (OKL) module, owned by the OKL schema. Its documented purpose is to store the objects associated with a quote — specifically, the financed cash flow or contract financing objects (CF_OBJECTS) that are linked to a lease or finance quote header at the time the quote is created or revised. In the ETRM data model, a quote (OKL_TRX_QUOTES_ALL_B) captures pricing, terms, and asset information before it is booked into a contract; the CF objects represent the underlying cost or financing components that drive the quoted economics. This table therefore acts as the association layer between a quote header and the financing objects that belong to it.

Under a heuristic Data Vault classification, the table exhibits satellite-leaning behaviour: its sole documented foreign key (QTE_ID → OKL_TRX_QUOTES_ALL_B) points to a single parent hub-like entity, and its wide descriptive/attribute column set is typical of a satellite carrying context about that parent. Treat this as a modeling suggestion rather than a normalized target.

Key Information Stored

The table comprises 26 documented columns. The most significant are:

• ID — the surrogate primary key uniquely identifying each object-to-quote association record.
• QTE_ID — foreign key to OKL_TRX_QUOTES_ALL_B; the business link tying the object to its parent quote.
• CFO_ID — identifier of the associated cash flow / contract financing object, the primary business reference in the row.
• BASE_SOURCE_ID — reference to the originating (base) source record from which the object was derived.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/ADF framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE — audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns tracking the most recent change.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS flexfield-seeded descriptive columns used for extensibility and customer-specific data capture.

The surrogate key is ID. QTE_ID and CFO_ID function as business-key candidates for the quote-to-object relationship; no unique index is documented in the supplied metadata. The ID plus the audit and attribute blocks follow the standard EBS "WHO" and DFF conventions.

Common Use Cases and Queries

Typical usage includes extracting the financing or cash flow objects attached to a given quote for pricing analysis, contract conversion validation, and reconciliation between quote-stage and contract-stage data.

• Listing all CF objects for a quote: SELECT id, qte_id, cfo_id, base_source_id FROM okl.okl_trx_qte_cf_objects WHERE qte_id = :qte_id;
• Joining to the quote header to enrich with quote number and status: SELECT q.quote_number, o.cfo_id FROM okl.okl_trx_qte_cf_objects o JOIN okl.okl_trx_quotes_all_b q ON q.id = o.qte_id;
• Audit and change-tracking reports filtered on last_update_date for a date range.
• Identifying orphaned or duplicate object associations by grouping on qte_id and cfo_id counts.
• Custom reporting via the DFF attributes (attribute_category, attribute1–15) where site-specific quote object metadata is stored.

Related Objects

• OKL_TRX_QUOTES_ALL_B — parent quote table; joined on OKL_TRX_QTE_CF_OBJECTS.QTE_ID = OKL_TRX_QUOTES_ALL_B.ID (documented FK).
• OKL_TRX_QUOTES_ALL_TL — translated quote header, joined through the parent for descriptive reporting.
• The contract financing / cash flow object tables referenced logically by CFO_ID, used to resolve object detail.
• OKL_TRX_QTE_CF_STRUCTURES / related quote CF tables — sibling quote-stage objects sharing the same QTE_ID lineage.
• OKL contract tables populated at booking, providing the downstream counterpart of the quote-stage associations.
• The OKL quote OAF/PLSQL APIs that insert and maintain rows in this table during quote creation and revision.