Results for “lease_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PN_TRX_LEASE_EXPENSE view is a reporting object in the Oracle E-Business Suite Property Manager (PN) module, owned by the APPS schema. It presents a denormalized, business-friendly projection of normalized lease payment expense data for leases classified as DIRECT. Rather than forcing report authors and integrators to join payment items, payment terms, leases, locations, lookups, and supplier tables manually, the view encapsulates those joins and exposes descriptive text values — lease numbers, supplier names, and lookup meanings — in place of raw foreign keys and codes.
The view is defined over PN_PAYMENT_ITEMS and filtered with the predicate ITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'NORMALIZED', which restricts output to normalized payment items. Its principal role is to support expense reporting and downstream integration for direct leases, allowing a single query to return the payment item identifier alongside human-readable lease, supplier, and payment classification attributes. The PAYMENT_ITEM_ID column, which is the term the user searched for, is the primary identifying column of the view.
Underlying Base Objects
The documented base objects referenced by this view are:
- FND_GLOBAL (PACKAGE) — the standard EBS globalization/context package invoked by the view definition.
- PN_PAYMENT_ITEMS (SYNONYM) — the driving table supplying
PAYMENT_ITEM_IDand the payment item type filter. - PN_PAYMENT_TERMS_ALL (SYNONYM) — supplies payment term attributes and the vendor, vendor site, location, purpose, and type references.
- PN_LEASES_ALL (SYNONYM) — supplies
LEASE_NUMandNAME, joined onLEASE_ID. - PN_LOCATIONS_ALL (SYNONYM) — outer-joined (
LOC.LOCATION_ID (+) = TERM.LOCATION_ID) to supplyLOCATION_CODE. - PO_VENDORS (VIEW) — supplies
VENDOR_NAME. - PO_VENDOR_SITES_ALL (VIEW) — supplies
VENDOR_SITE_CODE. - FND_LOOKUPS (VIEW) — referenced twice, once for
PN_PAYMENT_TERM_TYPEand once forPN_PAYMENT_PURPOSE_TYPE, to translate lookup codes into meanings.
Because the location join is an outer join, payment terms without an associated location still appear, with LOCATION_CODE returned as null.
Key Columns
- PAYMENT_ITEM_ID — Unique identifier of the normalized payment item, sourced from
PN_PAYMENT_ITEMS. This is the primary linkage key for expense transactions. - LEASE_NUMBER — Lease number from
PN_LEASES_ALL. - LEASE_NAME — Descriptive lease name.
- SUPPLIER_NAME — Vendor name from
PO_VENDORS. - SUPPLIER_SITE — Vendor site code from
PO_VENDOR_SITES_ALL. - PAYMENT_PURPOSE — Meaning of the payment purpose lookup (
PN_PAYMENT_PURPOSE_TYPE). - PAYMENT_TYPE — Meaning of the payment term type lookup (
PN_PAYMENT_TERM_TYPE). - LOCATION_CODE — Location code, null when no location is attached.
Common Use Cases and Queries
Typical uses include lease expense reporting, reconciliation of normalized payment items to suppliers and leases, and integration extracts keyed on PAYMENT_ITEM_ID. A representative query retrieving lease expense detail is:
SELECT payment_item_id, lease_number, lease_name, supplier_name, supplier_site, payment_purpose, payment_type, location_code FROM apps.pn_trx_lease_expense WHERE lease_number = :p_lease_number;
To target a specific payment item — the searched term — filter directly:
SELECT payment_item_id, lease_number, payment_type, payment_purpose FROM apps.pn_trx_lease_expense WHERE payment_item_id = :p_payment_item_id;
Aggregation by supplier and payment type is also common for spend analysis:
SELECT supplier_name, payment_type, COUNT(*) item_count FROM apps.pn_trx_lease_expense GROUP BY supplier_name, payment_type;
Because the view already resolves lookups and supplier joins, these queries avoid re-implementing the same joins and produce consistent, report-ready output.
-
View: PN_TRX_LEASE_EXPENSE 12.1.1
APPS.PN_TRX_LEASE_EXPENSE·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_LEASES_ALL·Explore PN module →
-
View: PN_TRX_LEASE_REVENUE 12.1.1
APPS.PN_TRX_LEASE_REVENUE·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS_ALL·Explore PN module →
-
View: PN_TRX_LEASE_REVENUE 12.2.2
APPS.PN_TRX_LEASE_REVENUE·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS_ALL·Explore PN module →
-
View: PN_TRX_LEASE_EXPENSE 12.2.2
APPS.PN_TRX_LEASE_EXPENSE·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_LEASES_ALL·Explore PN module →
-
Term History Header Form View.
APPS.PN_TERM_HISTORY_HEADER_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_LEASE_DETAILS_V 12.1.1
APPS.PN_LEASE_DETAILS_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_LEASE_DETAILS·Explore PN module →
-
View: PN_EXP_PAYMENT_ITEMS_V 12.1.1
APPS.PN_EXP_PAYMENT_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_LEASE_CHANGES_V 12.1.1
APPS.PN_LEASE_CHANGES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
APPS.PN_XLA_EXTRACT_HEADERS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS_ALL·Explore PN module →
-
View: PN_LEASES_V 12.2.2
APPS.PN_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
Term History Header Form View.
APPS.PN_TERM_HISTORY_HEADER_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
PN_SPACE_UTIL_LEASE_ITF Interface Table.
-
APPS.PN_LEASE_DETAILS_HISTORY_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_LEASE_DETAILS·Explore PN module →
-
View: PN_LEASE_DETAILS_V 12.2.2
APPS.PN_LEASE_DETAILS_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_LEASE_DETAILS·Explore PN module →
-
View: PN_PAYMENT_SCHEDULES_V 12.2.2
Form view used to input payment schedules information
APPS.PN_PAYMENT_SCHEDULES_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_PAYMENT_SCHEDULES·Explore PN module →
-
PN_MILESTONES_ITF Interface Table.
-
PN_MILESTONES_ITF Interface Table.
-
View: PN_SPACE_ASSIGN_CUST_V 12.2.2
APPS.PN_SPACE_ASSIGN_CUST_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore PN module →
-
View: PN_SPACE_ASSIGN_CUST_V 12.1.1
APPS.PN_SPACE_ASSIGN_CUST_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore PN module →
-
PN_SPACE_ASSIGN_LEASE_ITF Interface Table.
-
View: PN_LEASE_CHANGES_V 12.2.2
APPS.PN_LEASE_CHANGES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_INDEX_LEASES_V 12.1.1
Form view for table PN_INDEX_LEASES_ALL
APPS.PN_INDEX_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
APPS.PN_LEASE_DETAILS_HISTORY_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_LEASE_DETAILS·Explore PN module →
-
View: PN_VAR_RENTS_V 12.2.2
Form view used to input variable rent agreement related information.
APPS.PN_VAR_RENTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_VAR_RENTS_V 12.1.1
Form view used to input variable rent agreement related information.
APPS.PN_VAR_RENTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
Table: PN_LEASE_OPTIONS_ITF 12.2.2
PN_LEASE_OPTIONS_ITF Interface Table.
-
View: PN_PAYMENT_SCHEDULES_V 12.1.1
Form view used to input payment schedules information
APPS.PN_PAYMENT_SCHEDULES_V·↳ FND_USER·↳ PN_LEASES_ALL·↳ PN_PAYMENT_SCHEDULES·Explore PN module →
-
View: PN_EXP_PAYMENT_ITEMS_V 12.2.2
APPS.PN_EXP_PAYMENT_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_INDEX_LEASES_V 12.2.2
Form view for table PN_INDEX_LEASES_ALL
APPS.PN_INDEX_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_LEASES_V 12.1.1
APPS.PN_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
APPS.PN_XLA_EXTRACT_HEADERS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS_ALL·Explore PN module →
-
PN_SPACE_UTIL_LEASE_ITF Interface Table.
-
PN_RENT_ROLL_LEASE_EXP_ITF Interface Table.
-
PN_SPACE_ASSIGN_LEASE_ITF Interface Table.
-
PN_RENT_ROLL_LEASE_EXP_ITF Interface Table.
-
Table: PN_LEASE_OPTIONS_ITF 12.1.1
PN_LEASE_OPTIONS_ITF Interface Table.
-
VIEW: PN.PN_MILESTONES_ITF# 12.2.2
-
VIEW: APPS.PN_VAR_SUMM_DET_V 12.2.2