Results for “property_status”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_PROPERTIES_ALL is the master property definition table within the Oracle Property Manager (PN) module of Oracle E-Business Suite. It stores the core descriptive and classification information for every property managed by an organization, functioning as the foundational entity from which lease agreements, locations, recoverable expense agreements, and allocation structures are derived. In release 12.1.1 and 12.2.2, the table is owned by the PN schema and is documented as VALID within the ETRM repository, indicating it is a supported, actively maintained object.
From a data-modeling perspective, the FK relationship metadata suggests a hub-leaning classification. Nearly all foreign keys listed reference PN_PROPERTIES_ALL as the parent, with child tables carrying a PROPERTY_ID column pointing back to PN_PROPERTIES_ALL.PROPERTY_ID. This parent-position pattern is characteristic of a Data Vault hub, where the property surrogate key serves as the stable business nucleus around which transactional and descriptive satellites are organized.
Key Information Stored
The table is defined with a primary key constraint PN_PROPERTIES_ALL_PK on PROPERTY_ID, and a unique index PN_PROPERTIES_U1 on the same column. The conceptual separation of key roles is important: PROPERTY_ID is the surrogate system-generated primary key used throughout the PN schema as the foreign key target, while PROPERTY_CODE and PROPERTY_NAME serve as the human-readable business identifiers used in reporting and search. Both are documented columns and should be treated as the primary business-key candidates for user-facing lookup.
Among the 36 documented columns, the most significant are:
- PROPERTY_ID — surrogate primary key, referenced by all child tables.
- PROPERTY_CODE — business identifier used to uniquely label the property.
- PROPERTY_NAME — descriptive name of the property.
- PROPERTY_STATUS, ACTIVE_PROPERTY, CONDITION — lifecycle and operational state indicators.
- PORTFOLIO, CLASS, TENURE — portfolio grouping, asset class, and tenure type for financial reporting.
- LOCATION_PARK_ID, ZONE, DISTRICT, COUNTRY — geographic and hierarchical attributes of the property.
- DESCRIPTION — free-form narrative.
- ORG_ID — the operating unit (multi-org) discriminator.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) extension block.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — WHO audit columns.
Common Use Cases and Queries
The most frequent usage of this table is as the driving entity for property listing and portfolio reporting. A typical query joins PN_PROPERTIES_ALL to PN_LOCATIONS_ALL to obtain all physical locations associated with each property:
- Property master enquiry — SELECT PROPERTY_ID, PROPERTY_CODE, PROPERTY_NAME, PROPERTY_STATUS, PORTFOLIO FROM PN_PROPERTIES_ALL WHERE ORG_ID = :org_id AND ACTIVE_PROPERTY = 'Y'.
- Portfolio roll-up — aggregate property count and status grouped by PORTFOLIO, CLASS, or COUNTRY.
- Location join — SELECT p.PROPERTY_CODE, l.* FROM PN_PROPERTIES_ALL p, PN_LOCATIONS_ALL l WHERE p.PROPERTY_ID = l.PROPERTY_ID.
- Lease linkage — join to PN_REC_AGREEMENTS_ALL on PROPERTY_ID to review recoverable expense agreements per property.
- DFF extraction — query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for extended attribute reporting.
- Multi-org filtering — filter on ORG_ID to isolate a specific operating unit.
Related Objects
The documented foreign keys identify PN_PROPERTIES_ALL as a parent to several transaction and interface tables that carry a PROPERTY_ID column. The most significant are:
- PN_LOCATIONS_ALL — physical locations belonging to each property, joined on PROPERTY_ID.
- PN_LOCATIONS_ITF — interface table for location data, joined on PROPERTY_ID.
- PN_REC_AGREEMENTS_ALL — recoverable expense agreements per property, joined on PROPERTY_ID.
- PN_REC_EXPCL_ALL — recoverable expense clauses, joined on PROPERTY_ID.
- PN_REC_EXP_LINE_ALL and PN_REC_EXP_LINE_DTL_ALL — recoverable expense lines and details, joined on PROPERTY_ID.
- PN_REC_EXP_ITF — interface table for recoverable expense records.
- PN_REC_ARCL_ALL and PN_REC_ARCL_DTLLN_ALL — recoverable expense area class records, joined on PROPERTY_ID.
These dependencies confirm that PN_PROPERTIES_ALL is the central reference for all property-scoped transactions in the Property Manager module, and that PROPERTY_ID is the mandatory join key in nearly every downstream query.
-
Stores the properties information.
-
View: PN_PROPERTIES_V 12.2.2
APPS.PN_PROPERTIES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PN module →
-
View: PN_PROPERTIES_V 12.1.1
APPS.PN_PROPERTIES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PN module →
-
Stores the properties information.
-
VIEW: PN.PN_PROPERTIES_ALL# 12.2.2
-
VIEW: PN.PN_PROPERTIES_ALL# 12.2.2
-
TABLE: PN.PN_PROPERTIES_ALL 12.1.1
-
TABLE: PN.PN_PROPERTIES_ALL 12.2.2
-
VIEW: APPS.PN_PROPERTIES_V 12.1.1
-
VIEW: APPS.PN_PROPERTIES_V 12.2.2
-
VIEW: APPS.PN_PROPERTIES_V 12.2.2
-
VIEW: APPS.PN_PROPERTIES_V 12.1.1
-
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.