Search Results recovery_space_std




Overview
Explore in AI Chat

Overview

PN_TENANCIES_HISTORY_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 reporting view owned by the APPS schema and delivered with the Property Manager (PN) module. Its status is VALID, and it exposes a denormalised, read-only projection of tenancy history records held in the PN schema. The view combines core tenancy facts (occupancy and expiration dates, assignability, subleaseability, proportionate share, recovery attributes) with descriptive lookups and receivables customer information, so that downstream reports, concurrent programs, and integration extracts can retrieve a complete tenancy picture from a single selectable object rather than issuing multiple joins.

Because it surfaces historical tenancy rows, it is typically used for audit-style reporting, trend analysis of space utilisation, and reconciliation of sublease and assignable-area entitlements against lease and location measures. The user search term assignable_flag maps directly to a first-class column in this view, indicating the record's eligibility for assignment.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects:

The view therefore acts as a presentation layer over the PN tenancy history model, resolving foreign keys to human-readable values and to customer master data.

Key Columns

Common Use Cases and Queries

Typical uses include reporting assignable and subleaseable tenancies, area reconciliation, and customer-facing occupancy statements.

  • Identify assignable tenancies by location or lease.
  • Aggregate assignable versus usable area by customer.
  • List historical tenancies per lease with usage type and status.

Sample SQL:

  • SELECT TENANCY_ID, LEASE_ID, CUSTOMER_NAME, TENANCY_USAGE_TYPE, ASSIGNABLE_FLAG, SUBLEASEABLE_FLAG, STATUS, OCCUPANCY_DATE, EXPIRATION_DATE FROM APPS.PN_TENANCIES_HISTORY_V WHERE ASSIGNABLE_FLAG = 'Y' ORDER BY EXPIRATION_DATE;
  • SELECT CUSTOMER_NAME, SUM(LOCATION_ASSIGNABLE_AREA) ASSIGNABLE_AREA FROM APPS.PN_TENANCIES_HISTORY_V GROUP BY CUSTOMER_NAME;