Results for “pn_var_rent_adj_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_VAR_RENT_ADJ_V is a form view in the Oracle E-Business Suite Property Manager (PN) module, owned by the APPS schema and documented as VALID in both EBS 12.1.1 and 12.2.2. Its defined purpose is to present variable rent adjustment history details to the Property Manager forms layer, where users review how forecasted and actual variable rent amounts reconcile over successive invoicing periods. Rather than storing data itself, the view consolidates and derives values from the underlying variable rent invoice entity, adding calculated columns for cumulative invoiced amounts, per-unit rate variance, and term status flags. Because it is a reporting and forms-support object, it is typically queried read-only and is not intended as a transactional interface. The view also exposes descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15) and the multi-organization context column ORG_ID, consistent with other Property Manager views subject to organization-level security.

Underlying Base Objects

Per the documented ETRM metadata, the view references PN_VAR_RENT_CALC_PKG (a PL/SQL package) and PN_VAR_RENT_INV (a synonym). The view text confirms that the principal projection is from the PN_VAR_RENT_INV entity, aliased as INV, with additional joins to PN_VAR_PERIODS_ALL (aliased PER) and PN_VAR_RENTS_ALL (aliased RENT). A further inline subquery provides the INV_SCHEDULE_DATE value, sourced as GD.INV_SCHEDULE_DATE. The dependent package PN_VAR_RENT_CALC_PKG is used to derive and maintain variable rent calculations and adjustment scheduling logic consumed by these structures. Consequently, the view sits on top of the variable rent invoicing, period, and rent definition tables, making it a consolidated read layer rather than a normalization of any single base table.

Key Columns

• VAR_RENT_INV_ID — primary identifier of the variable rent invoice/adjustment record.
• INVOICE_DATE, ADJUST_NUM, PERIOD_ID — keys for ordering adjustment history and the analytic partition.
• FOR_PER_RENT, ACT_PER_RENT, VARIANCE — forecasted per-unit rent, actual per-unit rent, and their difference.
• ACTUAL_INVOICED_AMOUNT — cumulative amount computed via SUM OVER (PARTITION BY INVOICE_DATE, PERIOD_ID ORDER BY ADJUST_NUM, INVOICE_DATE).
• ADJUSTMENT — the individual ACTUAL_INVOICED_AMOUNT for the row, distinct from the running total.
• CONSTR_ACTUAL_RENT, ABATEMENT_APPL, NEGATIVE_RENT, TOT_ACT_VOL — constructed rent, abatement applied, negative rent indicator, and total actual volume.
• ACTUAL_TERM_STATUS, FORECASTED_TERM_STATUS, VARIANCE_TERM_STATUS — term-status codes for actual, forecasted, and variance comparisons.
• REC_ABATEMENT, REC_ABATEMENT_OVERRIDE — recommended abatement values.
• ORG_ID — organization identifier used for MOAC filtering.

Common Use Cases and Queries

Typical usage includes displaying adjustment history in the variable rent form and driving reconciliation reports that compare forecasted versus actual per-unit rent. Because ACTUAL_INVOICED_AMOUNT is a window function, the view preserves per-adjustment rows while supplying a running total. A representative query filters by period and invoice:

SELECT var_rent_inv_id, invoice_date, adjust_num, for_per_rent, act_per_rent, variance, actual_invoiced_amount, adjustment FROM apps.pn_var_rent_adj_v WHERE period_id = :p_period_id AND org_id = :p_org_id ORDER BY invoice_date, adjust_num;

Variance analysis is supported by ordering on variance or filtering negative rent rows, while status-based reporting groups by the three term-status columns to identify forecasted lines lacking an actual match. All queries should include ORG_ID for multi-org access consistency.