Search Results pn_index_exclude_term_v




Overview
Explore in AI Chat

Overview

The APPS.PN_INDEX_EXCLUDE_TERM_V view is a reporting and integration object within the Oracle Property Manager (PN) module, one of the EBS vertical applications supporting real estate and lease administration. It exposes payment terms associated with indexed leases alongside a computed indicator, EXCLUDE_FLAG, that signals whether a given payment term is explicitly excluded from index-based rent adjustments. The view is classified as VALID and is owned by the APPS schema, making it broadly accessible to concurrent programs, Oracle Reports, OA Framework pages, and custom SQL executed through the standard EBS responsibility model in both 12.1.1 and 12.2.2.

The view plays a central role in controlling indexation logic for lease schedules. Rather than querying exclusion data directly from the base table and manually joining to the lease and payment term structures, the view encapsulates the business rule that a term is considered included unless an exclusion record exists. This makes it particularly useful for ad hoc reporting on lease escalation behavior and for downstream integrations that require a clean, denormalized row per lease/term combination.

Underlying Base Objects

According to the ETRM 12.2.2 metadata, PN_INDEX_EXCLUDE_TERM_V is defined over three primary sources:

In addition, the documented dependency list includes the packages FND_GLOBAL, PNP_UTIL_FUNC, and PNT_PAYMENT_TERMS_PKG. These are consumed indirectly through the underlying view PN_PAYMENT_TERMS_V, which enforces security and organizational access rules via FND_GLOBAL and applies payment term derivation logic through the PNT_PAYMENT_TERMS_PKG package. As a result, the view inherits organization-level filtering and status resolution without exposing the complexity of the source objects.

Key Columns

Common Use Cases and Queries

The most frequent use is determining which terms are eligible for indexation versus those explicitly removed. For example:

  • Listing included terms: SELECT index_lease_id, payment_term_id, actual_amount FROM pn_index_exclude_term_v WHERE exclude_flag = 'Y';
  • Listing excluded terms: filter on exclude_flag = 'N'.
  • Lease-level review: join INDEX_LEASE_ID to lease headers to produce an indexation exclusion report per property.

Because the view already restricts to APPROVED terms through the DECODE on INDEX_PERIOD_ID and STATUS, report authors do not need to reapply approval logic, reducing the risk of inconsistent results across extracts and interfaces.