Results for “user_abstracted”

26 results




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

Overview

PN_VAR_RENTS_V is a form view owned by the APPS schema within the PN – Property Manager module of Oracle E-Business Suite (12.1.1 and 12.2.2). Its documented purpose is to support data entry of variable rent agreement information. Rather than storing data itself, the view presents a joined, denormalized result set drawn from the variable rent transaction table and its supporting lease, location, and lookup masters, so the Property Manager forms and any dependent reporting can read agreement details in a single pass.

The view is classified as VALID in the ETRM dictionary, confirming it is an active, deployed object. Its row identity is supplied by VARENT.ROWID exposed as ROW_ID, which is the conventional pattern Oracle Forms uses for updateable blocks — the forms layer can lock and modify the underlying PN_VAR_RENTS row through the view. It is therefore best understood as a UI-oriented projection rather than a general-purpose warehouse or interface view.

Underlying Base Objects

The view is defined primarily over PN_VAR_RENTS_ALL / PN_VAR_RENTS (aliased VARENT), which holds the variable rent agreement records. Surrounding denormalization is achieved by outer-joining or sub-querying related masters:

Because most of these are synonyms rather than tables, the view is schema-portable and resolves through the APPS synonyms into the PN base tables.

Key Columns

Common Use Cases and Queries

The dominant use case is the Variable Rent form, which queries the view by lease and displays decoded, human-readable agreement lines. Secondary use cases include ad-hoc reporting on active agreements, audit of abstracting users, and reconciliation of variable rents against lease terms.

Sample query listing agreements for a lease:

  • SELECT rent_num, lease_number, location_code, purpose, type, commencement_date, termination_date, uom, cumulative_vol FROM pn_var_rents_v WHERE lease_id = :p_lease_id ORDER BY commencement_date;

Sample query auditing agreements without an expiring term:

  • SELECT rent_num, lease_name, term_template, abatement_amount FROM pn_var_rents_v WHERE termination_date IS NULL OR termination_date > SYSDATE;

Queries should filter on indexed identifier columns such as LEASE_ID, LEASE_NUMBER, or VAR_RENT_ID. The scalar sub-query for LOCATION_CODE and the lookup joins impose cost, so full-table scans against the view are best avoided in high-volume reporting.