Search Results fnd_freq

Overview

APPS.OKL_CS_PPD_PAYMENTS_UV is a reporting view in the Oracle E-Business Suite ETRM (Enterprise Contracts and Lease Management) module, exposed under the APPS schema. It consolidates cash flow and payment schedule data for financial asset lines, primarily serving lease and contract payment reporting, quote-to-cash reconciliation, and downstream integration to financial or billing systems. The view flattens the deeply relational cash-flow model — objects, flows, and flow levels — into a single denormalized result set keyed by request, asset line, and stream, making it directly consumable by concurrent programs, Oracle Reports, BI Publisher templates, and OAF-based pages.

The suffix _UV follows the ETRM convention for a user-facing "user view" that supplies joined, presentation-ready data without requiring callers to navigate the underlying normalized tables. A distinguishing feature is its join to FND_LOOKUPS to resolve the frequency lookup code into a human-readable meaning, which is precisely why the view surfaces in searches involving FND_FREQ — the alias assigned to the FND_LOOKUPS instance in the view's SQL. In 12.1.1 and 12.2.2 the view's defining query is materially identical; the 12.2.2 metadata confirms foreign-key style joins via synonyms rather than direct base-table references.

Underlying Base Objects

The view is defined over the following documented objects:

• OKL_CASH_FLOWS (CAF) — the header-level cash flow record; supplies request context, arrears flag, stream type, and advance period counts.
• OKL_CASH_FLOW_LEVELS (CFL) — detail schedule lines; provides frequency code, number of periods, amount, stub days/amount, and start date.
• OKL_CASH_FLOW_OBJECTS (CFO) — links cash flows to source objects; contributes SOURCE_ID and filters on OTY_CODE = 'FINANCIAL_ASSET_LINE'.
• OKL_TRX_QTE_CF_OBJECTS (QCO) — associates cash flow objects with quote/contract line sources, yielding KLE_ID.
• OKC_K_LINES_V (L) — the contract line view supplying the asset name.
• OKC_K_HEADERS_B (HDR) — the contract header, providing currency code.
• OKL_STRM_TYPE_B (STM1) — stream type definition supplying STREAM_TYPE.
• FND_LOOKUPS (FND_FREQ) — the Oracle Application Object Library lookup view; joined with an outer (+) on LOOKUP_TYPE = 'OKL_FREQUENCY' and LOOKUP_CODE = CFL.FQY_CODE.
• FND_GLOBAL — referenced as a package dependency, typically for org/security context in ETRM views.

Key Columns

• REQUEST_ID — from CFO.SOURCE_ID; the cash flow request identifier.
• DNZ_KHR_ID — the contract header identifier from OKL_CASH_FLOWS.
• KLE_ID — the contract line (asset line) identifier from OKL_TRX_QTE_CF_OBJECTS.
• ASSET — descriptive asset name from OKC_K_LINES_V.
• STREAM_TYPE — coded stream type from OKL_STRM_TYPE_B.
• FREQUENCY_CODE / FREQUENCY — the raw lookup code and its decoded MEANING from FND_LOOKUPS, e.g. 'MONTHLY' rendered as "Monthly".
• ARREARS — due-in-arrears indicator from OKL_CASH_FLOWS.
• NUMBER_OF_PERIODS, AMOUNT, START_DATE — the payment schedule parameters from OKL_CASH_FLOW_LEVELS.
• STUB_DAYS, STUB_AMOUNT — first/last partial period treatment.
• ADVANCE_PAYMENTS — number of advance periods from OKL_CASH_FLOWS.
• CURRENCY_CODE — from the contract header.

Common Use Cases and Queries

Typical uses include extracting scheduled payment streams by asset, validating frequency setup against lookup meanings, and feeding billing or treasury interfaces. Because the lookup join is outer, schedules whose frequency code lacks a matching lookup still appear with a null FREQUENCY, which is useful for data-quality checks.

SELECT kle_id, asset, stream_type, frequency, arrears,
       number_of_periods, amount, start_date, currency_code
FROM   apps.okl_cs_ppd_payments_uv
WHERE  dnz_khr_id = :p_contract_id
ORDER  BY kle_id, stream_type, start_date;

To locate schedules using an undefined frequency lookup:

SELECT request_id, kle_id, frequency_code
FROM   apps.okl_cs_ppd_payments_uv
WHERE  frequency IS NULL;