Results for “date_billed”

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

Overview

The OKL_CS_PAYMENT_DETAIL_UV view is a reporting construct within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It exposes payment-level detail derived from lease contract streams, providing a consolidated, query-ready projection of billing and historical stream elements. The view is owned by the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2 environments. Its principal role is to support payment detail reporting and downstream integration by flattening the relationship between lease streams, their constituent stream elements, and contract header attributes such as currency. Because it joins contract header data to stream element data, it is particularly useful for reconciliation and billing analysis workstreams where users must trace amounts back to a specific contract and stream.

Underlying Base Objects

The view is defined as a UNION of two SELECT statements, each operating over the same three base objects. These are referenced through synonyms: OKC_K_HEADERS_B, OKL_STREAMS, and OKL_STRM_ELEMENTS. OKC_K_HEADERS_B is the contract headers base table from the Oracle Contracts core (OKC) schema, supplying the currency code. OKL_STREAMS holds the lease stream definitions and carries the KHR_ID contract reference, the KLE_ID lease identifier, the STY_ID stream type, the SAY_CODE stream category, and the ACTIVE_YN flag. OKL_STRM_ELEMENTS stores the individual stream elements, including the stream element date, amount, date billed, billing adjustment flag, and the SE_LINE_NUMBER.

The first branch of the UNION selects streams whose SAY_CODE equals 'CURR' and whose elements are either unbilled (DATE_BILLED IS NULL) or billed without a billing adjustment (BILL_ADJ_FLAG IS NULL). The second branch selects streams whose SAY_CODE equals 'HIST' where elements are billed and not adjusted. This design separates current stream activity from historical billed activity while presenting a uniform column set.

Key Columns

• KHR_ID — Contract header identifier, linking the payment detail to the originating contract.
• STREAM_ELEMENT_DATE — The effective date of the individual stream element.
• AMOUNT — The monetary value of the stream element.
• CURRENCY_CODE — Currency of the contract header, obtained from OKC_K_HEADERS_B.
• DATE_BILLED — Date on which the element was billed; NULL indicates an unbilled current element.
• SE_LINE_NUMBER — The stream element line number, providing sequencing and a unique identifier for the element within its stream. Users searching the term "se_line_number" typically reach this view to correlate individual stream elements to their line-level position.
• STM_ID — Identifier of the parent stream.
• KLE_ID — Lease identifier associated with the stream.
• STY_ID — Stream type identifier.

Common Use Cases and Queries

The view is commonly queried to list unpaid or unbilled current stream elements for a contract, to reconcile billed history against expected amounts, and to extract payment detail for external reporting. A representative query retrieving payment detail for a contract follows:

• SELECT khr_id, se_line_number, stream_element_date, amount, currency_code, date_billed FROM okl_cs_payment_detail_uv WHERE khr_id = :contract_id ORDER BY se_line_number;
• SELECT se_line_number, amount, date_billed FROM okl_cs_payment_detail_uv WHERE date_billed IS NULL ORDER BY khr_id, se_line_number;

Because the view does not restrict ACTIVE_YN in its second branch, users analyzing historical streams should filter explicitly where current-only data is required.