Results for “pn_right_status_type”

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

Overview

APPS.PN_RIGHTS_HISTORY_V is a reporting view in the Oracle Property Manager (PN) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It presents a consolidated, descriptive picture of lease rights — the contractual entitlements and obligations negotiated within a lease — while simultaneously exposing the audit trail of how those rights have changed over time. The view achieves this by combining the current state of each right, held in PN_RIGHTS, with its historical snapshots, held in PN_RIGHTS_HISTORY, using a UNION ALL construct. A CURRENT_FLAG column distinguishes the two sources, returning 'Y' for live records and a non-current indicator for historical ones.

Because the view resolves lookup codes into user-facing meanings, it is particularly well suited to ad hoc reporting, BI Publisher data models, and integration extracts where consumers require readable status and type descriptions rather than raw coded values. The concatenation of current and historical rows means the view functions as a single, unified source for rights lifecycle analysis.

Underlying Base Objects

The view is defined over the following documented objects:

• PN_RIGHTS (synonym) — the primary transactional table storing the current definition of each lease right, including its type, status, reference, and effective dates.
• PN_RIGHTS_HISTORY (synonym) — the audit table capturing prior versions of rights records as they are amended.
• FND_LOOKUPS (view) — joined twice, once against lookup type PN_RIGHTS_TYPE to decode RIGHT_TYPE_CODE, and once against lookup type PN_RIGHT_STATUS_TYPE to decode RIGHT_STATUS_CODE.
• FND_GLOBAL (package) — referenced for session context such as the current user and login, which influence row-level security and audit column population.

The join to FND_LOOKUPS is an inner join on LOOKUP_CODE and LOOKUP_TYPE, meaning a rights row is returned only when valid lookup entries exist for both its type and status codes.

Key Columns

• ROW_ID — the ROWID of the originating row in PN_RIGHTS or PN_RIGHTS_HISTORY, useful for identifying the physical source record.
• RIGHT_HISTORY_ID — populated only for historical rows; NULL for current records.
• RIGHT_ID — the identifier of the right, shared between its current and historical representations.
• LEASE_ID / LEASE_CHANGE_ID / NEW_LEASE_CHANGE_ID — context linking the right to its lease and any associated lease change.
• RIGHT_NUM — the human-readable sequence number of the right within the lease.
• RIGHT_TYPE_CODE / RIGHT_TYPE — the coded value and its decoded meaning from lookup type PN_RIGHTS_TYPE.
• RIGHT_STATUS_CODE / RIGHT_STATUS — the coded value and its decoded meaning from lookup type PN_RIGHT_STATUS_TYPE; this pair is the target of the common search term pn_right_status_type.
• RIGHT_REFERENCE, START_DATE, EXPIRATION_DATE, RIGHT_COMMENTS — descriptive and temporal attributes of the right.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle flexible attribute columns for descriptive flexfield data.
• CURRENT_FLAG — 'Y' when the row represents the live record in PN_RIGHTS.

Common Use Cases and Queries

Typical scenarios include determining the active status of all rights on a lease, auditing the progression of a right's status over time, and feeding rights data into downstream reporting without re-implementing lookup decoding.

To list current rights and their status meanings for a given lease:

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

To trace the history of a specific right:

SELECT right_id, right_status, last_update_date, last_updated_by
FROM   apps.pn_rights_history_v
WHERE  right_id = :right_id
ORDER  BY last_update_date;

To find all rights in a particular status across the enterprise:

SELECT lease_id, right_num, right_status
FROM   apps.pn_rights_history_v
WHERE  right_status_code = 'ACTIVE'
AND    current_flag = 'Y';