Search Results pn_var_lines_all




Overview
Explore in AI Chat

Overview

The PN_VAR_LINES_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module, specifically for the management of variable rent agreements. It stores the detailed line items associated with each calculation period for a variable rent. Each record represents a specific line item, such as a revenue component or a deduction, that contributes to the final variable rent amount for a given period. Its primary role is to persist the granular, period-specific calculations and definitions that aggregate to form the total variable rent obligation, serving as a critical link between high-level rent agreements and their periodic financial execution.

Key Information Stored

While the provided metadata does not list specific column names beyond key identifiers, the table's structure is defined by its primary and foreign key relationships. The primary key, LINE_ITEM_ID, uniquely identifies each line record. The table's foreign keys reveal the essential data entities it connects. The VAR_RENT_ID column links the line to its parent variable rent agreement in PN_VAR_RENTS_ALL. The PERIOD_ID column ties the line to a specific calculation period in PN_VAR_PERIODS_ALL. Furthermore, columns like LINE_TEMPLATE_ID, AGREEMENT_TEMPLATE_ID, and LINE_DEFAULT_ID connect the line to its definitional templates (PN_VAR_LINE_TEMPLATES_ALL, PN_VAR_TEMPLATES_ALL, PN_VAR_LINE_DEFAULTS_ALL), which govern its calculation logic, such as breakpoints, rates, and formulas.

Common Use Cases and Queries

This table is central to generating variable rent invoices and reports. Common operational and analytical queries involve joining to related tables to analyze rent calculations. A typical use case is auditing the calculated rent for a specific lease and period. A sample SQL pattern would retrieve all line items for a variable rent agreement within a date range, joining to period and rent header tables:

  • SELECT pvla.* FROM pn_var_lines_all pvla, pn_var_periods_all pvpa, pn_var_rents_all pvra WHERE pvla.period_id = pvpa.period_id AND pvla.var_rent_id = pvra.var_rent_id AND pvra.location_id = &location_id AND pvpa.start_date BETWEEN &date_from AND &date_to;

Another critical use case is tracing the source of a deduction or a specific revenue line by joining to PN_VAR_DEDUCTIONS_ALL or PN_VAR_BKPTS_HEAD_ALL using the LINE_ITEM_ID.

Related Objects

The PN_VAR_LINES_ALL table is a central hub in the variable rent schema, with extensive foreign key relationships. It references several parent tables for definitional data:

  • PN_VAR_PERIODS_ALL via PERIOD_ID
  • PN_VAR_RENTS_ALL via VAR_RENT_ID
  • PN_VAR_LINE_TEMPLATES_ALL via LINE_TEMPLATE_ID
  • PN_VAR_TEMPLATES_ALL via AGREEMENT_TEMPLATE_ID
  • PN_VAR_LINE_DEFAULTS_ALL via LINE_DEFAULT_ID

Conversely, its LINE_ITEM_ID is referenced as a foreign key by several child tables that store detailed calculation components:

  • PN_VAR_BKPTS_HEAD_ALL stores breakpoint details for the line.
  • PN_VAR_DEDUCTIONS_ALL stores deduction amounts applied to the line.
  • PN_VAR_VOL_HIST_ALL stores volume history used in line calculations.
  • PN_VAR_RENT_SUMM_ALL stores summary information for the line item.