Search Results pn_var_bkpts_det_all




Overview
Explore in AI Chat

Overview

The PN_VAR_BKPTS_DET_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. It functions as the detailed transactional repository for breakpoint definitions used in variable rent calculations. Variable rent, a common lease component, is often calculated based on a tenant's sales performance against predefined thresholds or "breakpoints." This table stores the specific breakpoint details for individual line items, enabling the system to compute the variable rent amount owed for a given period. Its ALL suffix indicates it is a multi-organization access enabled table, storing data for all operating units.

Key Information Stored

While the provided metadata does not list specific columns beyond the foreign keys, the table's primary purpose dictates the nature of its data. The primary key, BKPT_DETAIL_ID, uniquely identifies each breakpoint detail record. The table's relationships reveal its critical data linkages: it associates a breakpoint detail (BKPT_DETAIL_ID) with a specific variable rent agreement (VAR_RENT_ID), a breakpoint header (BKPT_HEADER_ID), and potentially a default breakpoint template (BKDT_DEFAULT_ID). Typical columns would include data points essential for calculation, such as the breakpoint threshold value, the rate or amount applied after reaching the threshold, the sequence of the breakpoint, and the applicable date ranges. It serves as the child table where the quantifiable rules for each tier of a variable rent schedule are defined.

Common Use Cases and Queries

This table is central to the generation of variable rent invoices and accruals. Common operational and reporting use cases include auditing the breakpoint structure for a lease, troubleshooting calculation discrepancies, and generating historical analyses of variable rent performance. A typical query would join this table to its parent tables to retrieve a complete variable rent schedule. For example, to list all breakpoint details for a specific variable rent agreement, a developer might use a pattern such as:

  • SELECT det.* FROM pn_var_bkpts_det_all det, pn_var_rents_all rent WHERE det.var_rent_id = rent.var_rent_id AND rent.lease_id = <lease_id>;

Data from this table is primarily accessed through the Property Manager application's variable rent setup and calculation forms, ensuring business logic and validations are applied.

Related Objects

The PN_VAR_BKPTS_DET_ALL table is a key junction in the variable rent data model, with documented foreign key relationships to several master tables. These relationships are fundamental for data integrity and application functionality:

  • PN_VAR_RENTS_ALL: Links via VAR_RENT_ID. This is the master table for variable rent agreements, defining the overall terms applicable to a lease.
  • PN_VAR_BKPTS_HEAD_ALL: Links via BKPT_HEADER_ID. This table stores the header information for a set of breakpoints, which are then detailed in this table.
  • PN_VAR_BKDT_DEFAULTS_ALL: Links via BKDT_DEFAULT_ID. This relationship allows breakpoint details to be seeded from predefined default templates, streamlining data entry.

The primary key constraint PN_VAR_BKPTS_DET_PK on BKPT_DETAIL_ID ensures each detail record is uniquely identifiable and can be reliably referenced.