Search Results okl_strm_type_b

Overview

The table OKL_STRM_TYPE_B is a core master data table within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as the central repository for defining and maintaining payment stream types, which are fundamental to structuring the financial cash flows associated with lease and finance contracts. Every payment, receipt, or financial stream generated within the OKL module is categorized by a type defined in this table. Its primary key (ID, referenced as STY_ID in foreign key relationships) is extensively used throughout the application's transactional and setup tables to enforce business rules, drive accounting, and enable accurate reporting on different classes of financial events, such as rent, interest, tax, or fee payments.

Key Information Stored

While the provided metadata does not list specific columns, based on its description as the holder of payment type definitions and its central role, the table typically contains columns that define the nature and behavior of a stream type. Common columns expected in such a table include a unique identifier (ID), a code (e.g., STY_CODE), a name (e.g., NAME), a description, and various control attributes. These attributes likely indicate the stream's direction (income or expense), its tax treatment, its impact on net investment, and its eligibility for specific processes. The table is a base table ('_B' suffix), implying it is the primary storage entity, often accompanied by a corresponding translation table (e.g., OKL_STRM_TYPE_TL) for multilingual support.

Common Use Cases and Queries

This table is critical for setup, transaction processing, and reporting. Administrators use it to define the universe of allowable payment types for contracts. Common operational queries involve joining OKL_STRM_TYPE_B to transactional stream tables to classify cash flows. For instance, to report all rental income streams from active contracts, a query would join OKL_STREAMS.STY_ID to OKL_STRM_TYPE_B.ID and filter on the relevant stream type code. Another key use case is in tax configuration, where specific stream types are linked to tax rules via the OKL_TAX_SOURCES table. A sample query to list all stream types and their related accounting templates would be: SELECT stb.name, aet.name FROM okl_strm_type_b stb, okl_ae_templates aet WHERE stb.id = aet.sty_id;

Related Objects

OKL_STRM_TYPE_B has a primary key relationship with a vast number of tables across the OKL module, underscoring its foundational importance. As documented, its primary key column (ID) is referenced as a foreign key (typically STY_ID) in numerous setup, transaction, and interface tables. Key related objects include:

• OKL_STREAMS: The main transactional table for payment streams.
• OKL_AE_TEMPLATES(_ALL): Links stream types to specific accounting templates.
• OKL_CASH_FLOWS: Associates stream types with projected cash flow calculations.
• OKL_TAX_SOURCES(_T): Configures the tax applicability for different stream types.
• OKL_SUBSIDIES_B / OKL_SUBSIDIES_ALL_B: Defines subsidy eligibility by stream type.
• OKL_EXT_AR_LINE_SOURCES_B / OKL_EXT_AP_LINE_SOURCES_B: Interfaces stream types to external Receivables and Payables systems.
• OKL_TXL_CNTRCT_LNS(_ALL) & OKL_TXL_AR_INV_LNS_B: Ties stream types to tax lines on contracts and invoices.
• OKL_SYSTEM_PARAMS_ALL: References a specific stream type for system-wide tax upfront configuration (TAX_UPFRONT_STY_ID).

This extensive network of foreign keys demonstrates that OKL_STRM_TYPE_B is a critical control point for financial data integrity and process flow within Oracle Lease Management.