Results for “date_from”

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

Overview

OKL_CS_VAT_SCHEDULES_UV is an APPS-owned, VALID database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the OKL product family, Oracle Leasing and Finance Management, and forms part of the contract-servicing (CS) reporting layer that supports Value Added Tax (VAT) determination and scheduling for lease and finance contracts. The view presents a flattened, presentation-ready projection of billing transaction data that has been enriched with tax-relevant attributes, allowing downstream reports, concurrent programs, and integrations to consume VAT schedule information without directly navigating the more complex transactional tables.

Because it is a view rather than a base table, OKL_CS_VAT_SCHEDULES_UV does not store data. Its results are materialized at query time from the underlying billing transaction view and supporting PL/SQL packages. This design centralizes VAT schedule logic and enforces consistent derivation rules across all consumers of the data.

Underlying Base Objects

Per the documented ETRM metadata for Release 12.2.2, the view is defined over the following referenced objects:

• OKL_CS_BILLINGTRX_UV (VIEW) — the primary source, aliased as CSBTRX in the view text, supplying transaction amounts, dates, and lease identifiers.
• FND_GLOBAL (PACKAGE) — provides session context such as the logged-in user, responsibility, and organization.
• OKL_BILLING_UTIL_PVT (PACKAGE) — billing utility logic used to derive or validate schedule attributes.
• OKL_CS_LC_CONTRACT_PVT (PACKAGE) — contract-level processing logic relevant to the lease or finance agreement.

The relationship is therefore layered: OKL_CS_VAT_SCHEDULES_UV depends entirely on OKL_CS_BILLINGTRX_UV for its row set, with the surrounding packages contributing derivation and context logic. Any change to the billing transaction view propagates directly into VAT schedule output.

Key Columns

The documented view columns include:

• TRANSACTION_AMOUNT — the monetary value of the billing transaction, sourced from CSBTRX.TRANSACTION_AMOUNT, representing the amount on which VAT is assessed.
• DATE_FROM — the schedule start date, mapped from CSBTRX.DUE_DATE, defining the beginning of the VAT period or installment window.
• DATE_TO — the schedule end date, mapped from CSBTRX.INVOICE_DATE, closing the period.
• IDX_ID — the lease/stream identifier, sourced from CSBTRX.LSM_ID, linking the VAT schedule row back to its originating lease transaction.
• INTEREST_RATE — documented as a column exposed by the view, supporting tax or finance computations tied to the schedule.

Together these columns describe a dated monetary stream per lease, which is precisely the shape required for periodic VAT reporting.

Common Use Cases and Queries

The view is typically consumed in VAT register and tax schedule reporting, reconciliation of billed versus scheduled VAT amounts, and interfaces that export lease tax data to financial or regulatory systems. A representative query follows:

SELECT idx_id, date_from, date_to, transaction_amount, interest_rate FROM apps.okl_cs_vat_schedules_uv WHERE date_from BETWEEN :p_from AND :p_to ORDER BY idx_id, date_from;

Analysts commonly join the view to OKL lease and contract tables on IDX_ID to enrich VAT schedules with customer, contract, and asset context. Because results depend on session context delivered through FND_GLOBAL, queries should be executed under an appropriate OKL responsibility to ensure correct organization and security filtering.