Search Results pn_index_leases_all




Overview
Explore in AI Chat

Overview

The PN_INDEX_LEASES_ALL table is a core data structure within the Oracle E-Business Suite Property Manager (PN) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for managing rent increases tied to an index-based escalation clause within a lease agreement. This table is fundamental for automating and tracking the financial adjustments that occur when a lease's rent is contractually linked to a published economic index, such as the Consumer Price Index (CPI). Its role is to define the relationship between a specific lease, the chosen index, and the associated calculation terms, thereby enabling the system to generate periodic rent adjustments throughout the lease's lifecycle.

Key Information Stored

While the provided metadata does not list individual columns, the documented foreign key relationships reveal the critical data linkages stored in this table. The primary identifier is the INDEX_LEASE_ID, which uniquely defines each index-lease association. The table stores the foreign key LEASE_ID, linking it to the master lease record in PN_LEASES_ALL. It also holds the INDEX_ID, which references the specific economic index definition in PN_INDEX_HISTORY_HEADERS. The TERM_TEMPLATE_ID links to PN_TERM_TEMPLATES_ALL, defining the calculation rules for the escalation. Furthermore, the BASE_INDEX_LINE_ID, referencing PN_INDEX_HISTORY_LINES, is crucial as it stores the specific historical index value used as the baseline for all future percentage increase calculations.

Common Use Cases and Queries

This table is primarily accessed during the setup of an index-based escalation clause for a lease and during the periodic generation of rent increase notices. Common operational and reporting scenarios include identifying all leases with pending or active index escalations, auditing the baseline index values for a set of leases, and troubleshooting calculation errors. A typical query would join PN_INDEX_LEASES_ALL to the lease and index tables to report on escalation setups.

  • Sample Query: To list active index leases with their base index information:
    SELECT ila.INDEX_LEASE_ID, l.LEASE_NUM, ih.INDEX_NAME, ila.BASE_INDEX_LINE_ID
    FROM PN_INDEX_LEASES_ALL ila,
    PN_LEASES_ALL l,
    PN_INDEX_HISTORY_HEADERS ih
    WHERE ila.LEASE_ID = l.LEASE_ID
    AND ila.INDEX_ID = ih.INDEX_ID
    AND l.LEASE_STATUS = 'ACTIVE';

Related Objects

The PN_INDEX_LEASES_ALL table sits at the center of a network of related objects that manage the details of index-based rent escalations. The documented foreign key relationships are as follows:

  • Referenced By This Table (Foreign Keys):
    • PN_LEASES_ALL via LEASE_ID
    • PN_INDEX_HISTORY_HEADERS via INDEX_ID
    • PN_INDEX_HISTORY_LINES via BASE_INDEX_LINE_ID
    • PN_TERM_TEMPLATES_ALL via TERM_TEMPLATE_ID
  • References This Table (Child Tables):