eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PN_LEASES_ALL

Product:	PN - Property Manager
Description:	Lease information
Implementation/DBA Data:	PN.PN_LEASES_ALL

Primary Key: PN_LEASE_PK1

LEASE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PN_LEASES_ALL	FND_USER	PN_LEASES_ALL.ABSTRACTED_BY_USER
PN_LEASES_ALL	HZ_CUST_ACCOUNTS	PN_LEASES_ALL.CUSTOMER_ID
PN_CONTACT_ASSIGNMENTS_ALL	PN_LEASES_ALL	PN_CONTACT_ASSIGNMENTS_ALL.LEASE_ID
PN_CONTACT_ASSIGN_HISTORY	PN_LEASES_ALL	PN_CONTACT_ASSIGN_HISTORY.LEASE_ID
PN_INDEX_LEASES_ALL	PN_LEASES_ALL	PN_INDEX_LEASES_ALL.LEASE_ID
PN_INSURANCE_REQUIREMENTS_ALL	PN_LEASES_ALL	PN_INSURANCE_REQUIREMENTS_ALL.LEASE_ID
PN_INSUR_REQUIRE_HISTORY	PN_LEASES_ALL	PN_INSUR_REQUIRE_HISTORY.LEASE_ID
PN_LANDLORD_SERVICES_ALL	PN_LEASES_ALL	PN_LANDLORD_SERVICES_ALL.LEASE_ID
PN_LANDLORD_SERVICE_HISTORY	PN_LEASES_ALL	PN_LANDLORD_SERVICE_HISTORY.LEASE_ID
PN_REC_AGREEMENTS_ALL	PN_LEASES_ALL	PN_REC_AGREEMENTS_ALL.LEASE_ID
PN_LEASE_CHANGES_ALL	PN_LEASES_ALL	PN_LEASE_CHANGES_ALL.LEASE_ID
PN_LEASE_DETAILS_ALL	PN_LEASES_ALL	PN_LEASE_DETAILS_ALL.LEASE_ID
PN_LEASE_DETAILS_HISTORY	PN_LEASES_ALL	PN_LEASE_DETAILS_HISTORY.LEASE_ID
PN_LEASE_MILESTONES_ALL	PN_LEASES_ALL	PN_LEASE_MILESTONES_ALL.LEASE_ID
PN_LEASE_TRANSACTIONS_ALL	PN_LEASES_ALL	PN_LEASE_TRANSACTIONS_ALL.LEASE_ID
PN_NOTE_HEADERS	PN_LEASES_ALL	PN_NOTE_HEADERS.LEASE_ID
PN_OPTIONS_ALL	PN_LEASES_ALL	PN_OPTIONS_ALL.LEASE_ID
PN_OPTIONS_HISTORY	PN_LEASES_ALL	PN_OPTIONS_HISTORY.LEASE_ID
PN_PAYMENT_SCHEDULES_ALL	PN_LEASES_ALL	PN_PAYMENT_SCHEDULES_ALL.LEASE_ID
PN_PAYMENT_TERMS_ALL	PN_LEASES_ALL	PN_PAYMENT_TERMS_ALL.LEASE_ID
PN_PAYMENT_TERMS_HISTORY	PN_LEASES_ALL	PN_PAYMENT_TERMS_HISTORY.LEASE_ID
PN_REC_AGREEMENTS_ALL	PN_LEASES_ALL	PN_REC_AGREEMENTS_ALL.LEASE_ID
PN_REC_ARCL_DTLLN_ALL	PN_LEASES_ALL	PN_REC_ARCL_DTLLN_ALL.LEASE_ID
PN_REC_EXPCL_DTLLN_ALL	PN_LEASES_ALL	PN_REC_EXPCL_DTLLN_ALL.LEASE_ID
PN_RIGHTS_ALL	PN_LEASES_ALL	PN_RIGHTS_ALL.LEASE_ID
PN_RIGHTS_HISTORY	PN_LEASES_ALL	PN_RIGHTS_HISTORY.RIGHT_ID
PN_SPACE_ASSIGN_CUST_ALL	PN_LEASES_ALL	PN_SPACE_ASSIGN_CUST_ALL.LEASE_ID
PN_TENANCIES_ALL	PN_LEASES_ALL	PN_TENANCIES_ALL.LEASE_ID
PN_TENANCIES_HISTORY	PN_LEASES_ALL	PN_TENANCIES_HISTORY.LEASE_ID
PN_VAR_RENTS_ALL	PN_LEASES_ALL	PN_VAR_RENTS_ALL.LEASE_ID