Search Results stm_stm_uk

Overview

The OKL_STREAMS table is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the central repository for payment stream header information. In the context of lease and finance contracts, a "stream" represents a scheduled series of financial cash flows, such as payments, receipts, or invoices. This table acts as the parent record, defining the high-level attributes and contractual linkage for a specific payment stream, while the detailed line-level amounts and dates are stored in related child tables. Its primary role is to establish the financial structure and obligations associated with a lease or finance agreement header and its constituent lines.

Key Information Stored

The table's structure is designed to link a payment stream to its relevant contract entities and classify its type. While the full column list is not provided in the metadata, the documented primary and foreign keys reveal its critical data points. The primary key (ID) uniquely identifies each stream record. The table enforces a unique constraint (STM_STM_UK) on a combination of columns that includes the stream type identifier (STY_ID), the contract header identifier (KHR_ID), a transaction number, and the contract line identifier (KLE_ID). This structure allows for multiple, uniquely identified streams per contract line. The essential foreign key columns are KHR_ID, linking to the lease header in OKL_K_HEADERS; KLE_ID, linking to the specific line item in OKL_K_LINES; and STY_ID, linking to the stream type definition in OKL_STRM_TYPE_B.

Common Use Cases and Queries

This table is fundamental for any process involving the generation, inquiry, or reporting of lease payments. Common use cases include generating payment schedules for a contract, calculating accrued revenue or expense, and performing portfolio-level cash flow analysis. A typical query would join OKL_STREAMS to its related tables to retrieve a comprehensive payment schedule. For example, to list all payment streams for a specific contract header, one might use a SQL pattern such as:

• SELECT stm.* FROM okl_streams stm, okl_k_headers khr WHERE stm.khr_id = khr.id AND khr.contract_number = '<CONTRACT_NUMBER>';

Reporting often involves aggregating data from child stream elements (OKL_STRM_ELEMENTS) grouped by the parent stream header in OKL_STREAMS to analyze total payment amounts by stream type or contract.

Related Objects

The OKL_STREAMS table sits at the center of a key data model. It has direct foreign key relationships with three primary tables: OKL_K_HEADERS (lease contracts), OKL_K_LINES (contract lines), and OKL_STRM_TYPE_B (stream types like "Rent" or "Interest"). Crucially, it is referenced as a parent table by objects that hold detailed transactional data. The most significant is OKL_STRM_ELEMENTS, which stores the individual payment amounts, dates, and statuses for each stream. Additionally, OKL_POOL_CONTENTS references STM_ID, linking payment streams to asset pools for securitization purposes. Understanding these relationships is essential for tracing financial data from a high-level contract down to its individual payment components.