PN — Property Manager
136 documented tables · 91 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PN_COMPANIES_ALL |
Information pertaining to a service provider | hub-leaning |
PN_LEASES_ALL |
Lease information | hub |
PN_VAR_RENTS_ALL |
Stores variable rent agreement information. | hub-leaning |
PN_PROPERTIES_ALL |
Stores the properties information. | hub-leaning |
PN_LEASE_CHANGES_ALL |
Lease abstracted, amended and edited | hub-leaning |
PN_LOCATIONS_ALL |
Space definition | hub |
PN_TERM_TEMPLATES_ALL |
PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults. | hub |
PN_PAYMENT_TERMS_ALL |
Payment and billing terms defined in a lease | satellite-leaning |
PN_ADDRESSES_ALL |
Information on locations and service providers | hub-leaning |
PN_INDEX_HISTORY_HEADERS |
PN_INDEX_HISTORY_HEADERS stores index information. Indexes help to account for inflation when calculating rent | hub-leaning |
PN_VAR_PERIODS_ALL |
Stores information about periods generated by the periods generation program for the duration of variable ren | hub-leaning |
PN_REC_AGREEMENTS_ALL |
Recovery Agreement set up table | satellite-leaning |
PN_INDEX_LEASES_ALL |
PN_INDEX_LEASES_ALL stores all the rent increases associated with an existing lease. | satellite-leaning |
PN_REC_ARCL_ALL |
Stores area class header information. | hub-leaning |
PN_REC_AGR_LINES_ALL |
Recovery Lines set up table | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PN_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
PN_INDEX_RENT_PUB |
PUB | 2 | 0 packages |
PN_LEASE_PUB |
PUB | 5 | 0 packages |
PN_VAR_RENT_PUB |
PUB | 4 | 0 packages |