Results for “right_type_code”

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

Overview

PN_RIGHTS_HISTORY_V is a valid, APPS-owned database view in the Oracle E-Business Suite Property Manager (PN) module, available in releases 12.1.1 and 12.2.2. It presents a consolidated, current-versus-historical record of property rights — the legal interests such as leases, easements, licenses, and similar encumbrances tracked against a property. The view is defined as a UNION ALL of two branches: one returning live rows from the PN_RIGHTS table and one returning prior versions from the PN_RIGHTS_HISTORY table. Each branch is joined to FND_LOOKUPS to resolve the right type code and the right status code into their translated meanings.

The distinguishing feature of the view is the RIGHT_HISTORY_ID column, which corresponds directly to the search term. For rows sourced from the current PN_RIGHTS table this column is populated as TO_NUMBER(NULL), while for rows sourced from PN_RIGHTS_HISTORY it carries the actual audit history identifier. A companion derived column, CURRENT_FLAG, is hard-coded to 'Y' in the current branch and defaults to 'N' in the historical branch, allowing consumers to distinguish live records from audit trail entries in a single query. The view therefore serves as the reporting and integration surface for right-level change tracking in Property Manager.

Underlying Base Objects

The ETRM 12.2.2 metadata lists four referenced base objects: PN_RIGHTS (SYNONYM), PN_RIGHTS_HISTORY (SYNONYM), FND_LOOKUPS (VIEW), and FND_GLOBAL (PACKAGE). The two PN synonyms resolve to the application tables that hold the current and archived versions of a property right. FND_LOOKUPS supplies the descriptive MEANING values for the lookup types PN_RIGHTS_TYPE and PN_RIGHT_STATUS_TYPE, which are joined on RIGHT_TYPE_CODE and RIGHT_STATUS_CODE respectively. FND_GLOBAL is referenced in the audit columns of the historical branch — typically through the WHO columns LAST_UPDATED_BY and CREATED_BY — to resolve the application user identity associated with each change.

Because the view is built on a UNION ALL over a live table and its history table, it does not itself store data. Its behaviour is entirely dependent on the presence and health of the underlying PN base tables and the two FND_LOOKUPS seed sets. Missing or disabled lookup codes for a given right would exclude that row from the result set, which is a common cause of apparently "missing" rights in reports.

Key Columns

• ROW_ID — the ROWID of the contributing row, used for row identification in forms and update processing.
• RIGHT_HISTORY_ID — NULL for current records; the audit identifier for archived versions. This is the primary discriminator when reconstructing change history.
• RIGHT_ID — the identifier of the property right itself, present on both current and historical rows.
• CURRENT_FLAG — 'Y' for rows from PN_RIGHTS, 'N' for rows from PN_RIGHTS_HISTORY.
• RIGHT_TYPE / RIGHT_STATUS — the decoded MEANING values from FND_LOOKUPS.
• RIGHT_NUM, RIGHT_REFERENCE, START_DATE, EXPIRATION_DATE — the core descriptive attributes of the right.
• LEASE_ID, LEASE_CHANGE_ID, NEW_LEASE_CHANGE_ID — linkage to the lease or lease change that gave rise to the right; NEW_LEASE_CHANGE_ID is NULL in the current branch.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include auditing changes to a lease right, producing a point-in-time reconstruction of a right's status, and feeding right-change data into external property systems. A simple query recovering the full history of a right is:

SELECT right_id, right_history_id, current_flag, right_type,
       right_status, start_date, expiration_date,
       last_update_date, last_updated_by
FROM   apps.pn_rights_history_v
WHERE  right_id = :right_id
ORDER  BY last_update_date;

To review only current rights with their decoded statuses:

SELECT right_id, right_num, right_type, right_status
FROM   apps.pn_rights_history_v
WHERE  current_flag = 'Y'
AND    lease_id = :lease_id;

To isolate the historical audit rows only:

SELECT right_history_id, right_id, right_status, last_update_date
FROM   apps.pn_rights_history_v
WHERE  current_flag = 'N';

Because the view is schema-qualified to APPS and joins FND_LOOKUPS without an ORG_ID or language restriction, callers querying via a read-only responsibility should confirm that the lookup rows for PN_RIGHTS_TYPE and PN_RIGHT_STATUS_TYPE are enabled and that no MO: Operating Unit or language seed filter is suppressing results.