Results for “cash_effect_yn”
32 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_SIF_FEES_V is an APPS-owned, VALID database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, belonging to the OKL (Leasing and Finance Management) product family. As documented in the ETRM metadata, the view "holds the fee and payment details required for external pricing." In practical terms, it serves as a read-oriented projection layer over the Stream Interface Fees (SIF) staging data, exposing the fee and payment attributes that the leasing engine passes to external pricing processes. The "SIF" prefix refers to the Stream Interface mechanism, through which Oracle Leasing assembles contract-level cash flow and pricing inputs prior to their consumption by pricing routines. The view therefore plays a bridging role between the transactional leasing tables and the external pricing engine, allowing pricing logic, integrations, and reports to read consolidated fee and payment detail without directly touching the underlying synonym or base table. The view text confirms it is a straightforward column projection over a single base object, with ROWID carried through as ROW_ID for row identification and OBJECT_VERSION_NUMBER supporting optimistic locking semantics.
Underlying Base Objects
Per the documented ETRM metadata for 12.2.2, the single referenced base object for OKL_SIF_FEES_V is OKL_SIF_FEES, exposed in the APPS schema as a SYNONYM. The view definition selects every meaningful column from this base object—SFEB, using the alias SFEB.ROWID as ROW_ID—without joins, unions, or aggregation. Consequently, OKL_SIF_FEES_V is a one-to-one row projection of OKL_SIF_FEES, meaning the view row count and cardinality mirror the base table exactly. The columns ID, SIF_ID, KLE_ID, and SIL_ID preserve the key relationships that tie individual fee records to their parent stream interface, lease, and line entities. Because no filtering predicates appear in the exposed view text, the view returns all fee and payment rows stored for the stream interface, making it suitable as a general-purpose read interface rather than a narrow reporting filter.
Key Columns
- CASH_EFFECT_YN — The column matched by the user's search. A Yes/No indicator specifying whether the fee or payment entry produces a cash effect in the pricing stream; this drives whether the amount participates in cash-flow-based pricing calculations.
- TAX_EFFECT_YN — Companion indicator flagging whether the fee is tax-relevant for pricing purposes.
- SFE_TYPE — The fee/stream interface type, classifying the nature of the fee or payment.
- AMOUNT, RATE, PERIOD, NUMBER_OF_PERIODS, DAYS_IN_PERIOD — The financial and time-basis attributes used to compute the fee contribution across periods.
- DATE_START, DATE_PAID — Effective start and payment dates supporting accrual and cash-flow timing.
- INCOME_OR_EXPENSE, IDC_ACCOUNTING_FLAG — Accounting classification flags indicating whether the item is income or expense and whether it flows through IDC accounting.
- ADVANCE_OR_ARREARS, STRUCTURE, LEVEL_TYPE, LEVEL_INDEX_NUMBER, LEVEL_LINE_NUMBER — Timing and structural placement of the fee within the contract level hierarchy.
- STREAM_INTERFACE_ATTRIBUTE01 through 14 — Extensible descriptive flexfield-style attributes carried into the pricing stream for external consumption.
- OBJECT_VERSION_NUMBER — Concurrency control column supporting the ORM (Object Relational Mapping) framework.
Common Use Cases and Queries
Typical use of this view includes validating which fees impact cash flow before submitting a contract for external pricing, reconciling fee amounts passed to the pricing engine, and building custom reports over SIF fee detail. A representative query filtering on the searched column is:
SELECT id, sfe_type, amount, cash_effect_yn, tax_effect_yn FROM apps.okl_sif_fees_v WHERE cash_effect_yn = 'Y' AND sif_id = :p_sif_id;
Analysts may also aggregate fee amounts by type while separating cash-effective from non-cash items:
SELECT sfe_type, cash_effect_yn, SUM(amount) FROM apps.okl_sif_fees_v GROUP BY sfe_type, cash_effect_yn;
Because the view is a direct projection of OKL_SIF_FEES, queries should include SIF_ID or ID predicates to maintain performance on high-volume stream interfaces, and read access should be granted through the APPS schema consistent with standard EBS security practice.
-
View: OKL_SIF_FEES_V 12.2.2
Holds the fee and payment details required for external pricing.
-
View: OKL_SIF_FEES_V 12.1.1
Holds the fee and payment details required for external pricing.
-
View on OKL_SIF_FEES & OKL_STREAM_INTERFACES.
APPS.OKL_ST_MAP_PERIODIC_FEES_V·↳ OKL_SIF_FEES·↳ OKL_STREAM_INTERFACES·Explore OKL module →
-
View on OKL_SIF_FEES & OKL_STREAM_INTERFACES.
APPS.OKL_ST_MAP_PERIODIC_FEES_V·↳ OKL_SIF_FEES·↳ OKL_STREAM_INTERFACES·Explore OKL module →
-
Holds the fee and payment details required for external pricing.
-
Holds the fee and payment details required for external pricing.
-
VIEW: OKL.OKL_SIF_FEES# 12.2.2
-
VIEW: OKL.OKL_SIF_FEES# 12.2.2
-
VIEW: APPS.OKL_SIF_FEES_V 12.2.2
-
VIEW: APPS.OKL_SIF_FEES_V 12.1.1
-
VIEW: APPS.OKL_SIF_FEES_V 12.2.2
-
TABLE: OKL.OKL_SIF_FEES 12.1.1
-
VIEW: APPS.OKL_SIF_FEES_V 12.1.1
-
TABLE: OKL.OKL_SIF_FEES 12.2.2
-
PACKAGE: APPS.OKL_SFE_PVT 12.1.1
-
PACKAGE: APPS.OKL_SFE_PVT 12.2.2
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards