Search Results okl_party_payment_hdr




Overview
Explore in AI Chat

Overview

The OKL_PARTY_PAYMENT_HDR table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a header-level repository for parameters associated with pass-through line items. In the context of lease contracts, a pass-through represents a cost (such as taxes, insurance, or maintenance) that is billed by the lessor to the lessee. This table serves as a control structure, storing the overarching definitions and rules for these pass-through charges at the individual contract line level. Its existence is critical for enabling the accurate calculation, invoicing, and tracking of pass-through amounts throughout the lifecycle of a lease agreement in both EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's primary and foreign key structure reveals its essential data points. The primary key, ID, uniquely identifies each pass-through header record. The table links to three fundamental entities: the lease contract via DNZ_CHR_ID (denormalized contract header ID), the specific contract line item via CLE_ID (linking to OKC_K_LINES_B), and the type of financial stream via PASSTHRU_STREAM_TYPE_ID (linking to OKL_STRM_TYPE_B). This structure indicates the table stores the relationship between a contract line and the configured pass-through stream type applied to it, forming the basis for subsequent detailed payment calculations.

Common Use Cases and Queries

This table is central to processes involving pass-through charge management. Common use cases include generating lessee invoices for pass-through costs, auditing the setup of pass-through terms on a contract line, and running reports to analyze pass-through revenue or expenses. A typical analytical query would join this header to its detail lines and related master data. For example, to list all pass-through setups for a specific contract, one might use a SQL pattern such as:

  • SELECT hdr.id, hdr.cle_id, hdr.passthru_stream_type_id, stm.name
  • FROM okl_party_payment_hdr hdr,
  • okl_strm_type_b stm
  • WHERE hdr.passthru_stream_type_id = stm.id
  • AND hdr.dnz_chr_id = <contract_id>;

This retrieves the header records and associated stream types for a given lease contract.

Related Objects

The OKL_PARTY_PAYMENT_HDR table is a nexus within a small but critical data model for pass-throughs. Its documented relationships are as follows:

  • Referenced Foreign Keys: The table references three parent tables:
    • OKC_K_LINES_B (via CLE_ID): The core contract lines table, linking the pass-through header to a specific line item in a lease contract.
    • OKL_STRM_TYPE_B (via PASSTHRU_STREAM_TYPE_ID): The streams type definition table, defining the nature (e.g., tax, insurance) and calculation rules for the pass-through.
    • Self-Reference (via DNZ_CHR_ID): Denormalized contract header identifier for partitioning or performance.
  • Referencing Foreign Key: The table is the parent to one key child table: