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_REC_AGREEMENTS_ALL

Product:	PN - Property Manager
Description:	Recovery Agreement set up table
Implementation/DBA Data:	PN.PN_REC_AGREEMENTS_ALL

Primary Key: PN_REC_AGREEMENTS_PK

REC_AGREEMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PN_REC_AGREEMENTS_ALL	PN_LEASES_ALL	PN_REC_AGREEMENTS_ALL.LEASE_ID
PN_REC_AGREEMENTS_ALL	PN_PROPERTIES_ALL	PN_REC_AGREEMENTS_ALL.PROPERTY_ID
PN_REC_AGREEMENTS_ALL	HR_ALL_ORGANIZATION_UNITS	PN_REC_AGREEMENTS_ALL.ORG_ID
PN_REC_AGREEMENTS_ALL	HZ_PARTIES	PN_REC_AGREEMENTS_ALL.CUSTOMER_ID
PN_REC_AGREEMENTS_ALL	PN_LEASES_ALL	PN_REC_AGREEMENTS_ALL.LEASE_ID
PN_REC_AGREEMENTS_ALL	PN_TERM_TEMPLATES_ALL	PN_REC_AGREEMENTS_ALL.TERM_TEMPLATE_ID
PN_REC_AGREEMENTS_ALL	HZ_CUST_SITE_USES_ALL	PN_REC_AGREEMENTS_ALL.CUST_SITE_ID
PN_REC_AGREEMENTS_ALL	PN_PROPERTIES_ALL	PN_REC_AGREEMENTS_ALL.PROPERTY_ID
PN_REC_AGREEMENTS_ALL	HZ_CUST_ACCOUNTS	PN_REC_AGREEMENTS_ALL.CUSTOMER_ID
PN_REC_PERIOD_BILL_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID
PN_REC_CALC_PERIODS_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID
PN_REC_AGR_LINES_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID
PN_REC_CALC_PERIODS_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID
PN_REC_PERIOD_BILL_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID
PN_REC_AGR_LINES_ALL	PN_REC_AGREEMENTS_ALL	PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID