Results for “option_term”

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

Overview

The PN_OPTIONS_HISTORY_V view is a reporting and integration construct within the Property Manager (PN) module of Oracle E-Business Suite, validated for releases 12.1.1 and 12.2.2. Its primary function is to present a unified, "current-state" projection of lease option records, bridging the distinction between active option rows held in PN_OPTIONS and their archived counterparts maintained in the PN_OPTIONS_HISTORY table. This design supports downstream reporting, contract management inquiries, and integration interfaces that must reconcile historical option data with the live lease record without requiring the consumer to join multiple PN tables independently.

The view is owned by the APPS schema. It exposes the OPTION_TYPE column derived from FND_LOOKUPS using lookup type PN_LEASE_OPTION_TYPE, which is directly relevant to searches on the term "option_type." The view also decodes option status codes via lookup type PN_OPTION_STATUS_TYPE, producing the OPTION_STATUS_TYPE column.

Underlying Base Objects

The documented referenced objects are FND_GLOBAL (package), FND_LOOKUPS (view), MTL_UNITS_OF_MEASURE (synonym), PN_OPTIONS (synonym), and PN_OPTIONS_HISTORY (synonym). The select text confirms the principal driver is PN_OPTIONS OPT, outer-joined in practice to the two lookup views and the unit-of-measure synonym.

• PN_OPTIONS — supplies all transactional option attributes, including OPTION_ID, LEASE_ID, and OPTION_TYPE_CODE.
• PN_OPTIONS_HISTORY — the archival partner table; the view text sets OPTION_HISTORY_ID and NEW_LEASE_CHANGE_ID to TO_NUMBER(NULL), indicating this projection represents the current (non-historical) row while reserving column slots for a sibling historical query.
• FND_LOOKUPS — referenced twice (aliases TLOOK and OLOOK) to translate coded values into user-facing meanings.
• MTL_UNITS_OF_MEASURE — provides the UNIT_OF_MEASURE descriptive name for the stored UOM_CODE.
• FND_GLOBAL — supplies session context (user and responsibility) for row-level security and audit column population.

Key Columns

• OPTION_TYPE_CODE / OPTION_TYPE — the stored code and its decoded meaning from lookup PN_LEASE_OPTION_TYPE.
• OPTION_STATUS_LOOKUP_CODE / OPTION_STATUS_TYPE — status code and its decoded meaning.
• OPTION_ID, LEASE_ID, LEASE_CHANGE_ID, OPTION_NUM — primary and foreign key identifiers.
• START_DATE, EXPIRATION_DATE, OPTION_TERM — the term is computed as TRUNC(EXPIRATION_DATE) - TRUNC(START_DATE) + 1.
• OPTION_SIZE, UOM_CODE, UNIT_OF_MEASURE — area/quantity and its unit.
• OPTION_EXER_START_DATE, OPTION_EXER_END_DATE, OPTION_ACTION_DATE — exercise window and action dates.
• OPTION_COST, OPTION_AREA_CHANGE, OPTION_REFERENCE, OPTION_NOTICE_REQD, OPTION_COMMENTS — commercial and descriptive attributes.
• CURRENT_FLAG — hard-coded 'Y', marking rows as the current version.
• ATTRIBUTE1 through ATTRIBUTE15, plus audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ROW_ID.

Common Use Cases and Queries

Typical usage includes lease-option workbench reporting, renewal/expiration monitoring, and interfaces feeding property or contract systems.

SELECT OPTION_ID, LEASE_ID, OPTION_NUM, OPTION_TYPE,
       OPTION_STATUS_TYPE, OPTION_TERM, EXPIRATION_DATE
FROM   APPS.PN_OPTIONS_HISTORY_V
WHERE  OPTION_TYPE = 'RENEWAL'
AND    EXPIRATION_DATE BETWEEN SYSDATE AND SYSDATE + 90;

A second pattern groups options by status for portfolio dashboards:

SELECT OPTION_STATUS_TYPE, COUNT(*)
FROM   APPS.PN_OPTIONS_HISTORY_V
GROUP  BY OPTION_STATUS_TYPE;

Because OPTION_TYPE is resolved through FND_LOOKUPS, filtering by meaning rather than by OPTION_TYPE_CODE is the recommended practice, and results are constrained by the lookup's current enabled state.