Search Results line_template_id

Overview

The PN_VAR_LINE_TEMPLATES_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module. It functions as the master repository for defining the structure and calculation rules for variable rent line items, organized by operating unit. This table enables the standardized setup of complex variable rent agreements, such as those based on percentage of sales or stepped rent schedules, ensuring consistent calculation logic is applied across multiple leases. Its role is critical in the configuration phase, where templates are defined and later instantiated within specific variable rent agreements, thereby separating setup from transactional execution.

Key Information Stored

The table's primary purpose is to store template definitions for variable rent lines. The most critical column is the LINE_TEMPLATE_ID, which serves as the unique primary key identifier for each template record. While the full column list is not detailed in the provided metadata, based on its described function, the table typically stores information such as the template name, description, associated organization (operating unit) identifier (indicating the ALL table structure), and configuration details for the rent calculation. This configuration likely includes references to calculation methods, breakpoint definitions, and associated accounts. The organization-specific design allows for multi-org implementations where line templates can differ by operating unit.

Common Use Cases and Queries

This table is primarily accessed during the setup and administration of variable rent agreements. A common use case is generating a list of all available line templates for a specific operating unit to be assigned to a new lease. Administrators may also query the table to audit setup or identify unused templates. A fundamental query retrieves template details using the primary key:

• Retrieve Template by ID: SELECT * FROM PN.PN_VAR_LINE_TEMPLATES_ALL WHERE LINE_TEMPLATE_ID = <id_value>;
• List Templates by Organization: SELECT LINE_TEMPLATE_ID, TEMPLATE_NAME FROM PN.PN_VAR_LINE_TEMPLATES_ALL WHERE ORG_ID = <org_id> ORDER BY TEMPLATE_NAME;

These templates are referenced when creating specific variable rent lines within the PN_VAR_RENT_LINES_ALL table, linking the predefined calculation logic to a specific lease and period.

Related Objects

The PN_VAR_LINE_TEMPLATES_ALL table is central to the variable rent setup hierarchy. Its primary key, LINE_TEMPLATE_ID, is documented as the sole column of the PN_VAR_LINE_TEMPLATES_PK primary key constraint. This identifier is almost certainly referenced by foreign key constraints in child transactional tables. The most direct relationship is expected with the PN_VAR_RENT_LINES_ALL table, where a foreign key column (likely also named LINE_TEMPLATE_ID) would link a specific calculated rent line instance back to its template definition. Other related objects may include views that consolidate template data for reporting and APIs within the PN_VAR_RENT_PKG or similar packages for creating and managing template data.