Results for “okl_quote_line_strm”

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

Overview

OKL_QUOTE_LINE_STRM is a reference table in the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. Its documented purpose is narrowly scoped: during termination quote billing, it indicates which stream type to use for each quote line. In practice, the table acts as the mapping layer between an individual termination quote line and the stream type that governs how that line is billed, ensuring that when a contract is quoted for early termination, the correct billing stream is applied rather than a default or contract-level stream.

The table is defined with primary key OKL_QUOTE_LINE_STRM_PK on the ID column, and it carries a foreign key from OKL_QUOTE_LINE_STRM.STY_ID to OKL_STRM_TYPE_B. The ETRM metadata marks this object as "Not implemented in this database," meaning the definition may exist in the data model for some environments or releases without a corresponding physical table. Under the heuristic Data Vault classification supplied in the metadata, the table is satellite-leaning. In Data Vault terms, that suggests it is best modeled as a satellite hanging off a parent business key (the quote line) while storing descriptive or qualifying attributes — here, the selected stream type — along with load metadata, rather than as a standalone hub or a link between two hubs.

Key Information Stored

The documented column set is limited, but the essential attributes are:

• ID — the surrogate primary key defined by OKL_QUOTE_LINE_STRM_PK. It uniquely identifies each row in the table and is the column used by downstream referential joins.
• STY_ID — the foreign key to OKL_STRM_TYPE_B. This is the operative business attribute: it identifies the stream type assigned to the quote line for termination quote billing purposes.
• Quote line identifier — the parent quote-line reference that ties each stream-type assignment to a specific termination quote line. This is the business-key candidate against which the surrogate ID is resolved; in the OKL model it normally corresponds to the quote line's primary key column.

The business-key candidates are the pairing of the quote line reference with STY_ID, which together determine the stream type applicable to a given line. The STY_ID value must resolve to an enabled, valid row in OKL_STRM_TYPE_B, since the foreign key enforces that only defined stream types can be assigned. Because the metadata explicitly records a single foreign key and a single-column primary key, consumers should treat ID as the technical row identifier and the quote-line-plus-stream-type pairing as the meaningful business identity.

Common Use Cases and Queries

The principal use case is termination quote generation. When the termination quote billing process assembles quote lines, it consults OKL_QUOTE_LINE_STRM to determine which stream type applies to each line. Reporting and reconciliation queries typically join the table back to the stream type definition to translate STY_ID into a human-readable stream name. A representative pattern:

• SELECT q.ID, q.STY_ID, s.NAME FROM OKL_QUOTE_LINE_STRM q JOIN OKL_STRM_TYPE_B s ON q.STY_ID = s.ID;
• Verify that every termination quote line has a stream-type assignment, and flag lines with no matching row as configuration exceptions.
• Compare the stream type assigned at the quote-line level against the stream type on the underlying contract to detect mismatches during termination quoting.
• Audit that no orphaned STY_ID values exist by left-joining to OKL_STRM_TYPE_B and filtering on NULL.

Because the object is documented as not implemented in the reference database, queries should confirm physical existence via the data dictionary before use, and any validation logic should degrade gracefully if the table is absent.

Related Objects

The following objects are the most significant to consider when working with OKL_QUOTE_LINE_STRM:

• OKL_STRM_TYPE_B — the immediate parent reference table, joined via OKL_QUOTE_LINE_STRM.STY_ID = OKL_STRM_TYPE_B.ID. This is the only foreign key documented for the table.
• OKL_QUOTE_LINE — the quote line entity that owns the termination quote line records referenced by this table.
• OKL_QUOTE — the header-level termination quote object that groups the quote lines.
• OKL_STRM_TYPE_TL — the translatable stream type name table, useful for reporting STY_ID values in the user's language.
• OKL_TRX_STRM_ALL — the transaction stream table that consumes stream type assignments during billing, providing the downstream link from quote to billing stream.
• Termination quote billing concurrent programs — the OKL processes that read this table to select the stream type per line.

Referential integrity on STY_ID should be preserved whenever rows are inserted or updated, since the foreign key guarantees consistency between quote-line stream assignments and the defined stream type catalog.