Search Results payment_status_code

Overview

The view APPS.OKL_PAYMENT_SCHDLE_DTLS_ALL_UV is a reporting and integration object within the Oracle E-Business Suite (EBS) Leasing and Finance Management module (OKL). It consolidates detailed payment schedule information derived from lease and finance contracts, presenting one row per payment schedule cash flow line together with its associated contract, stream type, line description, and monetary totals. The "_UV" suffix follows the Oracle Applications naming convention denoting a "User View," signifying that the object is intended as a stable, denormalized projection suitable for reporting, ad hoc queries, and downstream integration rather than for direct transactional update.

The view's principal value lies in its ability to flatten the complex relational structure that underlies lease payment scheduling. Payment schedules in OKL are stored as cash flows (OKL_CASH_FLOWS) qualified by a cash flow type code of PAYMENT_SCHEDULE. This view joins those cash flows to their parent contract headers, quote source lines, stream type definitions, and cash flow classification objects, producing a single readable result set. The user's search term payment_status_code maps directly to a documented column of this view, making it a focal point for status-driven reporting on scheduled payments.

Underlying Base Objects

The view is defined over a set of documented base and supplemental objects, all in the APPS schema:

• OKL_CASH_FLOWS (SYNONYM) — the driving table, aliased CAF, supplying schedule amounts, periods, status, and type codes.
• OKL_CASH_FLOW_LEVELS (SYNONYM) — linked via CAF_ID to associate cash flow detail levels.
• OKL_CASH_FLOW_OBJECTS (SYNONYM) — aliased CFO, providing the object type code (OTY_CODE) used in DECODE logic to classify line types.
• OKL_TRX_QTE_CF_OBJECTS (SYNONYM) — aliased QCO, mapping cash flow objects to their base source identifiers.
• OKC_K_HEADERS_ALL_B (SYNONYM) — the contract header, supplying currency code and contract ID.
• OKC_K_LINES_V (VIEW) — the contract line view, providing item name and description.
• OKC_K_ITEMS (SYNONYM) — aliased CIM, linking contract lines to stream type objects.
• OKL_STRM_TYPE_B (SYNONYM) and OKL_STRM_TYPE_V (VIEW) — stream type base and translated views supplying stream codes and names.
• OKL_ACCOUNTING_UTIL (PACKAGE) — referenced as a functional dependency of the view cluster.

Key Columns

• PAYMENT_STATUS_CODE — sourced from CAF.STS_CODE, the status of the payment schedule cash flow line. This is the column matched by the user's search term.
• QTE_ID / DNZ_KHR_ID — quote identifier and the contract header identifier used to anchor the schedule.
• DESCRIPTION — a DECODE-derived label resolving to asset, service, fee, or serviced asset names based on OTY_CODE.
• LINE_TYPE — a normalized classification (ASSET, SERVICE, FEE, SERVICED ASSET).
• STREAM_TYPE / STY_ID — the stream type code and its internal identifier.
• ADV_ARR / ADVANCE_PAYMENTS — indicates arrears versus advance payment and the number of advance periods.
• TOTAL — the computed sum of amount times periods plus stub amounts.
• CURRENCY_CODE / CFT_CODE — the contract currency and the cash flow type (constant PAYMENT_SCHEDULE).

Common Use Cases and Queries

Typical uses include reporting outstanding versus paid schedules, reconciling expected cash inflows by stream type, and exposing schedule detail to external systems via interface tables.

SELECT DNZ_KHR_ID, DESCRIPTION, STREAM_TYPE,
       TOTAL, CURRENCY_CODE, PAYMENT_STATUS_CODE
FROM   APPS.OKL_PAYMENT_SCHDLE_DTLS_ALL_UV
WHERE  PAYMENT_STATUS_CODE = 'ACTIVE';

Aggregation by contract and status is equally common:

SELECT DNZ_KHR_ID, PAYMENT_STATUS_CODE, SUM(TOTAL) TOTAL_AMT
FROM   APPS.OKL_PAYMENT_SCHDLE_DTLS_ALL_UV
GROUP  BY DNZ_KHR_ID, PAYMENT_STATUS_CODE;

Because the view enforces CFT_CODE = 'PAYMENT_SCHEDULE' internally, consumers need not filter on that column, though it remains available for verification.