Results for “stream_type_subclass”

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

Overview

The OKL_SEC_INVESTOR_REVENUE_UV view is an Oracle E-Business Suite database object owned by the APPS schema within the OKL (Leasing and Finance Management) product module. It is classified as a user interface view designed specifically to present securitization investor revenue information. In the context of Oracle EBS 12.1.1 and 12.2.2, this view acts as a reporting and integration layer, abstracting the complexity of the underlying contract and line tables into a streamlined, business-friendly result set that can be consumed by Oracle Forms-based UI screens, concurrent programs, OAF pages, or external integration interfaces. The view has a VALID status in the documented environment, confirming it is compiled and available for query.

The view exposes investor revenue share data derived from the OKL stream type subclass lookup, filtering only revenue-sharing contract lines and excluding lines marked as ABANDONED. This makes it a targeted data source for securitization reporting where investors hold a percentage or fixed stake in lease revenue streams.

Underlying Base Objects

The view is defined over several base objects. The primary source is OKL_K_LINES (synonym KLEB), which supplies the stake percentage, stake amount, and stream type subclass. Contract line information is drawn from OKC_K_LINES_B, which appears twice in the FROM clause (aliased CLET for the top line and CLES for the child line). Line style information is retrieved from OKC_LINE_STYLES_B (LSEB), and the view is restricted to lines whose line type code equals 'REVENUE_SHARE'. Descriptive lookup values are joined from FND_LOOKUPS (FNDS) using the OKL_STREAM_TYPE_SUBCLASS lookup type. The documented metadata also references FND_GLOBAL as a package used within the OKL environment, typically for session context such as organization or user identification.

The join chain links KLEB.ID to CLES.ID, CLES.CLE_ID to CLET.ID, and CLES.LSE_ID to LSEB.ID, ensuring that each row represents a valid revenue-share line with its associated top line and style definition.

Key Columns

The view exposes sixteen columns. Notable among them is DATE_TERMINATED, which records the date on which the securitization investor revenue line was terminated. This column is central to the user's search, as it allows filtering for active versus terminated revenue streams. Other important columns include:

• ID and TOP_LINE_ID — unique identifiers for the child line and its parent top line.
• PERCENT_STAKE and AMOUNT_STAKE — the investor's proportional or fixed monetary stake in the revenue stream.
• LSE_ID — references the line style identifier.
• DNZ_CHR_ID — the associated contract or charter identifier.
• START_DATE and END_DATE — the effective period of the revenue line.
• STS_CODE — the status code, with 'ABANDONED' lines excluded by the view definition.
• CURRENCY_CODE, LINE_NUMBER, DISPLAY_SEQUENCE, and EXCEPTION_YN — presentation and control attributes.
• STY_SUBCLASS_CODE and STREAM_TYPE_SUBCLASS — the lookup code and its descriptive meaning.

Common Use Cases and Queries

Typical usage involves reporting on active investor revenue shares, reconciling securitization disbursements, and identifying terminated streams for audit or accrual reversal. A practitioner searching for "date_terminated" would likely construct a query to isolate currently active lines:

• SELECT id, top_line_id, percent_stake, amount_stake, date_terminated FROM apps.okl_sec_investor_revenue_uv WHERE date_terminated IS NULL;
• SELECT id, lse_id, start_date, end_date, stream_type_subclass FROM apps.okl_sec_investor_revenue_uv WHERE date_terminated BETWEEN :start AND :end;
• SELECT dnz_chr_id, SUM(amount_stake) FROM apps.okl_sec_investor_revenue_uv WHERE date_terminated IS NULL GROUP BY dnz_chr_id;

These queries support reconciliation, termination tracking, and aggregate exposure reporting across securitization portfolios.