Search Results pn_lease_change_type




Overview
Explore in AI Chat

Overview

APPS.PN_LEASE_TRANSACTIONS_V is a reporting view in the Oracle E-Business Suite Property Manager (ETRM) module. It presents lease transaction records joined to their descriptive change types, the associated lease change identifiers, and the name of the user who created each record. The view is defined over the lease transaction and lease change base objects and enriches them with decoded lookup meanings, providing a denormalized, human-readable projection of lease activity suitable for reporting and integration.

Because it is a view rather than a table, it carries no independent storage and inherits the security model of its base objects, including the ORG_ID column exposed for multi-organization access control. The view is owned by the APPS schema and is the object referenced in the ETRM 12.2.2 documentation.

Underlying Base Objects

The view is defined over the following documented base objects:

Unlike a table, the view does not enforce referential constraints itself; correctness depends on the underlying keys. All joins are inner joins, so a lease transaction appears only when a matching lookup, change record, and user exist.

Key Columns

  • ROW_ID — the ROWID of the PN_LEASE_TRANSACTIONS row.
  • LEASE_TRANSACTION_ID — primary transaction identifier.
  • LEASE_ID — the parent lease.
  • LOCATION_ID — the location associated with the transaction.
  • TRANSACTION_TYPE_CODE — the raw TRANSACTION_TYPE code stored in PN_LEASE_TRANSACTIONS.
  • TRANSACTION_TYPE — the decoded lookup meaning for lookup type PN_LEASE_CHANGE_TYPE.
  • LEASE_CHANGE_ID — identifier from PN_LEASE_CHANGES_ALL.
  • DATE_EFFECTIVE — the effective date of the transaction.
  • CREATED_BY_NAME — the FND_USER user_name of the creator.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
  • ORG_ID — the operating unit, used for multi-org filtering.

Common Use Cases and Queries

Typical uses include lease change reporting, audit of who created transactions, and integration extracts keyed on lease change types.

List decoded transaction types for a lease:

SELECT lease_transaction_id, transaction_type,
       transaction_type_code, date_effective
FROM   apps.pn_lease_transactions_v
WHERE  lease_id = :p_lease_id
ORDER  BY date_effective;

Find transactions by decoded change type:

SELECT lease_id, transaction_type, created_by_name
FROM   apps.pn_lease_transactions_v
WHERE  transaction_type = 'Rent Increase'
AND    org_id = :p_org_id;

Audit transactions created by a user:

SELECT lease_transaction_id, lease_change_id,
       transaction_type, creation_date
FROM   apps.pn_lease_transactions_v
WHERE  created_by_name = :p_user_name;

Queries should be constrained by ORG_ID to respect multi-organization security.