Search Results pn_rec_agr_linarea_all




Overview
Explore in AI Chat

Overview

The PN_REC_AGR_LINAREA_ALL table is a core setup table within the Property Manager (PN) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction table that establishes the relationship between recovery agreement lines and the specific recovery area classifications assigned to them. Its primary role is to define which physical or logical areas (e.g., common areas, specific building floors) are subject to recovery charges as stipulated in a lease agreement. This table is fundamental to the automated calculation and billing of occupancy costs, such as operating expenses and real estate taxes, ensuring charges are correctly allocated to tenants based on the areas they occupy.

Key Information Stored

The table's structure centers on linking key identifiers and storing area allocation details. The primary key column, REC_AGR_LINAREA_ID, uniquely identifies each record. The most critical foreign key columns are REC_AGR_LINE_ID, which links to the PN_REC_AGR_LINES_ALL table to associate the area with a specific recovery agreement line, and AREA_CLASS_ID, which links to the PN_REC_ARCL_ALL table to specify the type or classification of area being recovered. The ORG_ID column implements the multi-organization architecture standard in EBS, partitioning the data by operating unit. Collectively, these columns define the precise scope of recoverable space for a given charge on a lease.

Common Use Cases and Queries

This table is central to inquiries and reports regarding chargeable areas under a lease. A common operational use case is validating the setup of a recovery agreement to ensure all intended areas are correctly linked before generating invoices. For reporting, it is frequently joined to retrieve a tenant's recoverable area breakdown. A typical query pattern involves joining to agreement header and line tables, as well as the area class descriptions.

  • Sample Query: Retrieving all recovery areas for a specific agreement line.
    SELECT prala.rec_agr_line_id, prala.area_class_id, prc.name area_class_name
    FROM pn_rec_agr_linarea_all prala, pn_rec_arcl_all prc
    WHERE prala.area_class_id = prc.area_class_id
    AND prala.rec_agr_line_id = :p_rec_agr_line_id
    AND prala.org_id = :p_org_id;

Related Objects

PN_REC_AGR_LINAREA_ALL is a child table with strong dependencies on several key Property Manager objects, as indicated by its foreign keys. Its primary relationship is with PN_REC_AGR_LINES_ALL, the table for recovery agreement lines. It also depends on PN_REC_ARCL_ALL, the master table for recovery area classifications. For multi-org context, it references HR_ALL_ORGANIZATION_UNITS. This table is typically accessed indirectly via the standard Property Manager APIs and forms for creating and maintaining recovery agreements. Reports on recovery schedules or tenant chargeback details will invariably join to this table to resolve area information.