Search Results okl_st_map_header_v

Overview

OKL_ST_MAP_HEADER_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OKL product family (Leasing and Finance Management), part of the Enterprise Contracts and lease management stack. The view presents a denormalized, header-level projection of the OKL_STREAM_INTERFACES table, exposing lease/pricing stream header attributes such as implicit interest rate, lending rate, RVI details, funding, term, and payment dates. Its status is documented as VALID.

Because OKL_STREAM_INTERFACES is the staging/interface structure through which lease pricing data flows between source systems and the OKL lease engine, this view functions as a read-only consumption surface. It allows reporting tools, concurrent programs, and downstream interfaces to read stream header information without directly touching the base interface table. In practice it is used where a flattened set of header attributes is required, notably for extracting financial terms such as IMPLICIT_INTEREST_RATE alongside contract identifiers and structure codes.

Underlying Base Objects

The view is defined over a single documented referenced base object: OKL_STREAM_INTERFACES (accessed via a SYNONYM in the APPS schema). The view text selects directly from OKL_STREAM_INTERFACES across 41 columns, with no documented joins, aggregations, or filters. Consequently, the view is a straight column projection rather than a transformed data set: every row in OKL_STREAM_INTERFACES maps one-to-one to a row in OKL_ST_MAP_HEADER_V.

Note that the view text names the FASB column as FASB_ACCT_TREATMENT_METHOD, while the documented column list shows FASB_ACCOUNTING_TREATMENT_METH (an Oracle truncated alias representation). Columns such as DATE_SEC_DEPOSIT_COLLECTED appear in the column list as DATE_SECURITY_DEPOSIT_COLLECTE, reflecting the 30-character naming limit. The presence of 15 generic STREAM_INTERFACE_ATTRIBUTE01–15 columns indicates a flexfield-style extension mechanism for capturing client-specific values during stream import.

Key Columns

• ID / TRANSACTION_NUMBER / KHR_ID — Primary identifier, source transaction reference, and contract/header reference keys, used to correlate the stream header with the originating lease.
• IMPLICIT_INTEREST_RATE — The implicit rate applied to the lease stream; this is the column most directly relevant to the searched term and is central to interest and yield calculations.
• LENDING_RATE — The lending rate associated with the funding of the stream.
• TOTAL_FUNDING — Total funding amount for the stream header.
• RVI_YN / RVI_RATE — Residual value insurance indicator and rate.
• TERM / STRUCTURE / FIRST_PAYMENT / LAST_PAYMENT / DATE_PAYMENTS_COMMENCEMENT — Lease term, structure type, and payment schedule dates.
• SECURITY_DEPOSIT_AMOUNT / DATE_SEC_DEPOSIT_COLLECTED — Security deposit amount and collection date.
• FASB_ACCT_TREATMENT_METHOD / IRS_TAX_TREATMENT_METHOD — Accounting treatment for FASB and tax treatment for IRS reporting.
• SIF_MODE / PRICING_TEMPLATE_NAME / SIS_CODE / ORP_CODE / ADJUST / ADJUSTMENT_METHOD — Interface mode, pricing template, SIS/ORP codes, and adjustment controls.
• COUNTRY / DATE_DELIVERY / DATE_PROCESSED — Geographic and processing dates.
• STREAM_INTERFACE_ATTRIBUTE01–15 — Generic descriptive/extension attributes for interface-specific data.

Common Use Cases and Queries

Typical usage includes auditing imported stream headers, extracting implicit interest rates for pricing analysis, and validating accounting treatment flags before the interface is processed. Reporting extracts frequently join the view to lease headers using KHR_ID.

• Retrieve the implicit interest rate for a given transaction:

  SELECT transaction_number, implicit_interest_rate, lending_rate
  FROM   okl_st_map_header_v
  WHERE  transaction_number = :p_txn_number;

• List streams by structure and term:

  SELECT khr_id, structure, term, first_payment, last_payment
  FROM   okl_st_map_header_v
  WHERE  structure = :p_structure;

• Audit accounting and tax treatment:

  SELECT id, fasb_accounting_treatment_meth, irs_tax_treatment_method
  FROM   okl_st_map_header_v
  FETCH FIRST 100 ROWS ONLY;

Because the view is a direct projection, queries should apply selective predicates on TRANSACTION_NUMBER or KHR_ID to avoid full scans of the interface table.