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:
PN_LEASES_ALL(aliasLEASE) — supplies lease name, lease number, and lease class.PN_LEASE_DETAILS_ALL(aliasLDET) — supplies lease commencement and termination dates.PN_LOCATIONS/PN_LOCATIONS_ALL(aliasPLO) — resolved via a scalar sub-query to returnLOCATION_CODEfor the agreement's location.PN_TERM_TEMPLATES_ALL/PN_VAR_TEMPLATES_ALL(aliasTEMPLATE) — supplies the term template name.FND_LOOKUPSandFND_USER— supply decoded lookup meanings for purpose and type codes, and the user name of the abstracting user.FND_GLOBAL— referenced for session context such as organization and user identifiers.PN_PROPERTIES_ALL— referenced in the wider object graph for property-level context.
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
ROW_ID,VAR_RENT_ID,RENT_NUM— surrogate row identity, primary key, and the user-facing rent agreement number.LEASE_ID,LEASE_NAME,LEASE_NUMBER,LEASE_CLASS_CODE— lease linkage and classification.LEASE_COMMENCEMENT_DATE,LEASE_TERMINATION_DATE— inherited lease term boundaries; distinct from the agreement's ownCOMMENCEMENT_DATEandTERMINATION_DATE.CURRENCY_CODE,LOCATION_ID,LOCATION_CODE,PRORATION_DAYS— pricing, site, and proration inputs.PURPOSE_CODE/PURPOSE,TYPE_CODE/TYPE— code plus decoded meaning pairs fromFND_LOOKUPS.UOM,CUMULATIVE_VOL,ACCRUAL,ROUNDING,INVOICE_ON,NEGATIVE_RENT— variable rent calculation and billing controls.TERM_TEMPLATE_ID,TERM_TEMPLATE,ABATEMENT_AMOUNT,ABSTRACTED_BY_USER_ID,USER_ABSTRACTED— template, concession, and audit attribution.ATTRIBUTE_CATEGORYandATTRIBUTE1–ATTRIBUTE15— the standard EBS DFF flexfield segment set.
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.
-
View: PN_VAR_RENTS_V 12.1.1
Form view used to input variable rent agreement related information.
APPS.PN_VAR_RENTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_LEASE_CHANGES_V 12.1.1
APPS.PN_LEASE_CHANGES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_LEASES_V 12.2.2
APPS.PN_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_LEASE_CHANGES_V 12.2.2
APPS.PN_LEASE_CHANGES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_VAR_RENTS_V 12.2.2
Form view used to input variable rent agreement related information.
APPS.PN_VAR_RENTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
View: PN_VAR_VOL_HIST_V 12.2.2
Form view used to input volume history related information.
APPS.PN_VAR_VOL_HIST_V·↳ FND_USER·↳ PN_VAR_VOL_HIST·Explore PN module →
-
View: PN_VAR_VOL_HIST_V 12.1.1
Form view used to input volume history related information.
APPS.PN_VAR_VOL_HIST_V·↳ FND_USER·↳ PN_VAR_VOL_HIST·Explore PN module →
-
View: PN_LEASES_V 12.1.1
APPS.PN_LEASES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_USER·Explore PN module →
-
VIEW: APPS.PN_VAR_VOL_HIST_V 12.1.1
-
VIEW: APPS.PN_VAR_VOL_HIST_V 12.2.2
-
VIEW: APPS.PN_LEASES_V 12.2.2
-
VIEW: APPS.PN_VAR_VOL_HIST_V 12.1.1
-
VIEW: APPS.PN_VAR_VOL_HIST_V 12.2.2
-
VIEW: APPS.PN_LEASES_V 12.1.1
-
VIEW: APPS.PN_VAR_RENTS_V 12.1.1
-
VIEW: APPS.PN_VAR_RENTS_V 12.2.2
-
VIEW: APPS.PN_LEASES_V 12.2.2
-
VIEW: APPS.PN_LEASES_V 12.1.1
-
VIEW: APPS.PN_VAR_RENTS_V 12.1.1
-
VIEW: APPS.PN_VAR_RENTS_V 12.2.2
-
eTRM - PN Tables and Views 12.1.1
Interface table to contain batch lines information.
-
eTRM - PN Tables and Views 12.2.2
Interface table to contain batch lines information.