Search Results expense_class_line_id

Overview

The PN_REC_EXPCL_DTLLN_ALL table is a core data structure within the Oracle E-Business Suite Property Manager (PN) module, specifically in the context of lease accounting and recovery. It functions as a child table, storing granular line-level details for expense classes that are associated with a summary header. This table is critical for the detailed tracking and allocation of recoverable expenses (such as common area maintenance, utilities, or taxes) to specific tenants or customer space assignments within a leased property. Its design supports multi-organization architecture, as indicated by the '_ALL' suffix and the foreign key to HR_ALL_ORGANIZATION_UNITS, allowing it to store data partitioned by operating unit.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships definitively indicate the critical data elements stored. The primary key is EXPENSE_CLASS_LINE_ID. Each record links to a parent expense class summary header via EXPENSE_CLASS_DTL_ID (referencing PN_REC_EXPCL_DTL_ALL). Crucially, it establishes the connection between an expense and the specific customer or tenant being charged through CUST_SPACE_ASSIGN_ID (linking to PN_SPACE_ASSIGN_CUST_ALL) and the associated accounting flexfield via CUST_ACCOUNT_ID (linking to GL_CODE_COMBINATIONS). The LEASE_ID column ties the expense line to a specific property lease in PN_LEASES_ALL. The ORG_ID column provides multi-org context.

Common Use Cases and Queries

This table is central to generating tenant recovery statements and ensuring accurate expense pass-through accounting. Common operational and reporting scenarios include analyzing recoverable expenses for a specific lease or tenant, auditing expense allocations, and troubleshooting reconciliation issues. A typical query would join this table to its parent header and related master data to produce a detailed recovery schedule.

Sample Query Pattern:

• SELECT dlln.*, dtl.summary_amount, cust.customer_id, lease.lease_num
• FROM pn_rec_expcl_dtlln_all dlln,
• pn_rec_expcl_dtl_all dtl,
• pn_space_assign_cust_all cust,
• pn_leases_all lease
• WHERE dlln.expense_class_dtl_id = dtl.expense_class_dtl_id
• AND dlln.cust_space_assign_id = cust.cust_space_assign_id
• AND dlln.lease_id = lease.lease_id
• AND lease.lease_id = <lease_number>;

Related Objects

The table exists within a tightly integrated hierarchy of Property Manager tables. As documented, its primary relationships are:

• Parent Tables (Foreign Key References From):
  • PN_REC_EXPCL_DTL_ALL: Via EXPENSE_CLASS_DTL_ID. This is the direct parent header.
  • PN_LEASES_ALL: Via LEASE_ID. Provides the lease context.
  • PN_SPACE_ASSIGN_CUST_ALL: Via CUST_SPACE_ASSIGN_ID. Identifies the specific customer/tenant space assignment.
  • GL_CODE_COMBINATIONS: Via CUST_ACCOUNT_ID. Links to the General Ledger account for the customer.
  • HR_ALL_ORGANIZATION_UNITS: Via ORG_ID. Provides the operating unit context.
• Child Tables (Foreign Key References To):
  • PN_REC_EXPCL_DTLACC_ALL: References EXPENSE_CLASS_LINE_ID. This table likely stores accounting distributions or accruals generated from these expense class lines.