Results for “pre_tax_yn”

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

Overview

The view OKL_ST_MAP_TARGETS_V is an Oracle E-Business Suite dictionary object owned by the APPS schema within the OKL (Leasing and Finance Management) product. It is defined as a join view whose purpose is to expose structured yield target information tied to stream interface records used during the flow of financial data through the ETRM (Enterprise Transaction and Revenue Management) subsystem. The view presents only those yield records where a target value has been populated, effectively acting as a filtered projection of yield targets combined with their associated stream interface attributes.

Because it resides in the APPS schema and is documented as a VALID object, it is intended for consumption by concurrent programs, report generators, and interfaces within the Leasing module rather than for direct transactional DML. Its role is primarily read-oriented: it consolidates target yield type definitions with adjustment-related attributes so that downstream logic — rate mapping, yield curve processing, or stream interface mapping — can query a single, denormalized structure instead of joining the base tables independently. The leading column, TARGET_TYPE, is the attribute most commonly searched by users, as it identifies the classification of each target yield row.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed through SYNONYM entries in the APPS schema:

• OKL_SIF_YIELDS (aliased SIYB) — the primary source of target yield detail, providing the yield type, index number, nominal/pre-tax flags, and target value.
• OKL_STREAM_INTERFACES (aliased SIFB) — the stream interface record supply adjustment attributes, adjustment method, and transaction number.

The join is established through the correlation SIYB.SIF_ID = SIFB.ID and is further constrained by the predicate SIYB.TARGET_VALUE IS NOT NULL. This means the view returns one row per yield record that carries a non-null target, enriched with the corresponding stream interface context. The relationship is therefore one of a filtered inner join between yield definitions and stream interfaces.

Key Columns

• TARGET_TYPE — Sourced from OKL_SIF_YIELDS.SIY_TYPE. Identifies the yield type classification of the target record.
• TARGET_TYPE_INDEX — Sourced from SIY.INDEX_NUMBER. Provides the sequence or index of the yield type.
• NOMINAL_YN — Indicates whether the yield is a nominal (nominal-flag) target.
• PRE_TAX_YN — Indicates whether the target value is expressed on a pre-tax basis.
• TARGET_VALUE — The numeric target associated with the yield record; rows where this is null are excluded by the view.
• ADJUST — From OKL_STREAM_INTERFACES; the adjustment indicator carried on the stream interface.
• ADJUSTMENT_METHOD — The method by which adjustments are applied to the stream.
• TRANSACTION_NUMBER — The transaction identifier linking the target to a specific stream interface transaction.

Common Use Cases and Queries

Typical usage centres on validating and mapping yield targets for stream interfaces. A common query filters by target type:

• SELECT TARGET_TYPE, TARGET_TYPE_INDEX, TARGET_VALUE, TRANSACTION_NUMBER FROM APPS.OKL_ST_MAP_TARGETS_V WHERE TARGET_TYPE = :p_type;
• SELECT TARGET_TYPE, NOMINAL_YN, PRE_TAX_YN, ADJUSTMENT_METHOD FROM APPS.OKL_ST_MAP_TARGETS_V WHERE PRE_TAX_YN = 'Y' AND ADJUST = 'Y';
• SELECT TRANSACTION_NUMBER, COUNT(*) FROM APPS.OKL_ST_MAP_TARGETS_V GROUP BY TRANSACTION_NUMBER;

These queries support reconciliation of yield targets, identification of taxable versus nominal targets, and determination of the adjustment method applicable to each stream interface transaction, all without requiring direct joins against the underlying OKL_SIF_YIELDS and OKL_STREAM_INTERFACES synonyms.