Search Results pn_index_exclude_term




Overview
Explore in AI Chat

Overview

APPS.PN_INDEX_EXCLUDE_TERM_V is a reporting and integration view in the Oracle Property Manager (PN) module, delivered as part of Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents payment terms associated with index leases alongside a derived indicator showing whether each term is excluded from indexation processing. Its central purpose is to reconcile two logically related data sets: the universe of approved payment terms belonging to index leases (sourced from PN_PAYMENT_TERMS_V) and the specific subset of those terms that have been explicitly flagged for exclusion in the PN_INDEX_EXCLUDE_TERM table.

The view is defined in the APPS schema and is exposed to reporting tools, concurrent programs, and custom extensions that need a single, denormalized source for exclusion analysis. Because Property Manager indexation frequently drives rent adjustments on leases with variable terms, the ability to distinguish included versus excluded terms is material to accurate financial reporting and to downstream payables activity.

Underlying Base Objects

The view is defined over three primary sources via an outer join structure:

  • PN_INDEX_EXCLUDE_TERM (referenced as a synonym) — the exclusion fact table holding payment terms explicitly marked as not subject to indexation, together with WHO columns and ORG_ID for multi-org security.
  • PN_PAYMENT_TERMS_V (view) — the approved payment terms for leases, providing term attributes and the lease linkage.
  • PN_INDEX_LEASES_ALL (synonym) — the index lease header supplying INDEX_LEASE_ID.

The join is driven by an outer join (EXCLUDE.PAYMENT_TERM_ID(+) = TERMS.PAYMENT_TERM_ID), ensuring all qualifying payment terms appear even when no exclusion record exists. The predicate DECODE(TERMS.INDEX_PERIOD_ID, NULL, 'APPROVED', TERMS.STATUS) = 'APPROVED' restricts output to terms considered approved under Property Manager business rules. Documented package references include PNP_UTIL_FUNC, PNT_PAYMENT_TERMS_PKG, and FND_GLOBAL, consistent with the view's dependency on standard EBS security and utility logic.

Key Columns

Common Use Cases and Queries

Typical usages include identifying which approved terms on an index lease are excluded from indexation, auditing exclusion decisions, and driving reports that reconcile exclusions against term amounts.

List approved terms and their exclusion status for an index lease:

SELECT payment_term_id, exclude_flag, payment_term_type, actual_amount
FROM apps.pn_index_exclude_term_v
WHERE index_lease_id = :p_lease_id
ORDER BY start_date;

Retrieve only terms excluded from indexation (EXCLUDE_FLAG = 'N'):

SELECT payment_term_id, actual_amount
FROM apps.pn_index_exclude_term_v
WHERE exclude_flag = 'N';

Because ORG_ID is exposed, multi-org-aware queries should filter on the operating unit via MO_GLOBAL or the appropriate security profile to respect data partitioning.