Results for “var_rent_type”

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

Overview

PN_FOR_RENT_DETAILS_V is a VALID view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PN - Property Manager module. Its documented purpose is to present actual variable rent details broken down by line item and group date, making it a reporting-oriented object rather than a transactional entry point. The view is available in both EBS 12.1.1 and 12.2.2 and is defined in the ETRM reference for 12.2.2 with the owner APPS and a defined set of referenced base objects.

Variable rent in Property Manager is calculated against volume-driven breakpoints, prorated across the boundary of reporting periods and group date ranges. PN_FOR_RENT_DETAILS_V exposes that proration logic in a flattened, query-ready form. Rather than requiring report developers to reconstruct proration arithmetic, the view invokes the PN_VARIABLE_AMOUNT_PKG API to derive prorated breakpoint volumes at the start and end of each group date range, then computes the applied volume and the resulting variable rent amount. This makes the view suitable for operational reporting, reconciliation of variable rent calculations, and downstream integration extracts.

Underlying Base Objects

The view text joins five primary sources and is documented as referencing the following objects: PN_VARIABLE_AMOUNT_PKG (package), PN_VAR_BKPTS_DET_ALL, PN_VAR_BKPTS_HEAD, PN_VAR_BKPTS_HEAD_ALL, PN_VAR_GRP_DATES_ALL, PN_VAR_PERIODS_ALL, PN_VAR_RENTS, and PN_VAR_RENT_SUMM_ALL (synonyms).

• PN_VAR_RENTS (VR) — supplies the cumulative volume and organization identifier driving breakpoint determination.
• PN_VAR_PERIODS_ALL (PER) — provides the period start and end dates used as the proration window.
• PN_VAR_GRP_DATES_ALL (GD) — supplies group date, invoice date, group start and end dates, proration factor, and the actual, forecasted, and variance expenditure codes.
• PN_VAR_RENT_SUMM_ALL (SUMM) — contributes the line item identifier and total volume for volume (TOT_FOR_VOL).
• PN_VAR_BKPTS_HEAD / PN_VAR_BKPTS_HEAD_ALL and PN_VAR_BKPTS_DET_ALL — an inline subquery over the breakpoint header and detail structures supplies breakpoint rates and period/group breakpoint volume boundaries.
• PN_VARIABLE_AMOUNT_PKG — the packaged API GET_PRORATED_BKPT is called repeatedly to compute prorated breakpoint volumes, and is central to the view's derived columns.

Key Columns

• GROUP_DATE / INVOICE_DATE — the group date context and associated invoice date for the variable rent line.
• LINE_ITEM_ID — the line item to which the variable rent detail belongs.
• TOT_VOL — the total volume summarized for the line item (aliased from SUMM.TOT_FOR_VOL).
• BKPT_VOL_START / BKPT_VOL_END — prorated breakpoint volumes at the start and end of the group date range, derived via GET_PRORATED_BKPT.
• VOL_APPL — the volume actually applied within the group date range, computed as the difference between the prorated end and start breakpoint volumes.
• BKPT_RATE — the breakpoint rate applicable to the segment.
• VAR_RENT — the calculated variable rent, being VOL_APPL multiplied by BKPT_RATE.
• ACTUAL_EXP_CODE / FORECASTED_EXP_CODE / VARIANCE_EXP_CODE — expenditure code assignments for actual, forecasted, and variance accounting treatment.
• VAR_RENT_TYPE — a literal value, 'FORECASTED', indicating the rent type represented by the row.
• ORG_ID — the operating unit identifier, supporting multi-org filtering.

Common Use Cases and Queries

Typical uses include variable rent reconciliation reports, breakpoint utilization analysis, and feeds extracting prorated variable rent by line item. Because the view returns ORG_ID, queries should filter by operating unit where multi-org security applies.

• Reconcile variable rent by line item and group date:
  SELECT line_item_id, group_date, tot_vol, vol_appl, bkpt_rate, var_rent FROM apps.pn_for_rent_details_v WHERE org_id = :p_org_id ORDER BY line_item_id, group_date;
• Extract prorated breakpoint consumption for a period:
  SELECT group_date, invoice_date, bkpt_vol_start, bkpt_vol_end, vol_appl FROM apps.pn_for_rent_details_v WHERE group_date BETWEEN :p_from AND :p_to AND org_id = :p_org_id;
• Aggregate variable rent totals by expenditure code:
  SELECT actual_exp_code, SUM(var_rent) FROM apps.pn_for_rent_details_v WHERE org_id = :p_org_id GROUP BY actual_exp_code;

Because the view performs row-wise calls to PN_VARIABLE_AMOUNT_PKG.GET_PRORATED_BKPT, performance is sensitive to volume; restricting by ORG_ID, GROUP_DATE, and LINE_ITEM_ID materially reduces execution cost in reporting queries.