This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: | The accounting events table |
|---|
PN.PN_ACCOUNTING_EVENTS_ALL does not reference any database object
PN.PN_ACCOUNTING_EVENTS_ALL is referenced by following:
| Description: | Information on locations and service providers |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_COMPANY_SITES_ALL.ADDRESS_ID | PN_ADDRESSES_ALL |
| PN_LOCATIONS_ALL.ADDRESS_ID | PN_ADDRESSES_ALL |
PN.PN_ADDRESSES_ALL does not reference any database object
PN.PN_ADDRESSES_ALL is referenced by following:
| Description: | Details of an adjustment. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_DETAILS.TERM_HISTORY_ID | PN_PAYMENT_TERMS_HISTORY |
| PN_ADJUSTMENT_DETAILS.ADJUSTMENT_SUMMARY_ID | PN_ADJUSTMENT_SUMMARIES |
| PN_ADJUSTMENT_DETAILS.PAYMENT_ITEM_ID | PN_PAYMENT_ITEMS_ALL |
PN.PN_ADJUSTMENT_DETAILS does not reference any database object
PN.PN_ADJUSTMENT_DETAILS is referenced by following:
| Description: | Summary of Adjustement. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_SUMMARIES.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_DETAILS.ADJUSTMENT_SUMMARY_ID | PN_ADJUSTMENT_SUMMARIES |
PN.PN_ADJUSTMENT_SUMMARIES does not reference any database object
PN.PN_ADJUSTMENT_SUMMARIES is referenced by following:
| Description: | The accounting headers table |
|---|
PN.PN_AE_HEADERS_ALL does not reference any database object
PN.PN_AE_HEADERS_ALL is referenced by following:
| Description: | The accounting lines table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_AE_LINES_ALL.THIRD_PARTY_ID | HZ_PARTIES |
PN.PN_AE_LINES_ALL does not reference any database object
PN.PN_AE_LINES_ALL is referenced by following:
| Description: | Information pertaining to a service provider |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_COMPANIES_ALL.PARENT_COMPANY_ID | PN_COMPANIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_COMPANIES_ALL.PARENT_COMPANY_ID | PN_COMPANIES_ALL |
| PN_COMPANY_SITES_ALL.COMPANY_ID | PN_COMPANIES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_ID | PN_COMPANIES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.COMPANY_ID | PN_COMPANIES_ALL |
PN.PN_COMPANIES_ALL does not reference any database object
PN.PN_COMPANIES_ALL is referenced by following:
| Description: | Site information of a service provider |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_COMPANY_SITES_ALL.COMPANY_ID | PN_COMPANIES_ALL |
| PN_COMPANY_SITES_ALL.ADDRESS_ID | PN_ADDRESSES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACTS_ALL.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
PN.PN_COMPANY_SITES_ALL does not reference any database object
PN.PN_COMPANY_SITES_ALL is referenced by following:
| Description: | Contact information identified at the site level of a service provider |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACTS_ALL.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PHONES_ALL.CONTACT_ID | PN_CONTACTS_ALL |
PN.PN_CONTACTS_ALL does not reference any database object
PN.PN_CONTACTS_ALL is referenced by following:
| Description: | Llinks locations or leases with the site of a service provider. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_ID | PN_COMPANIES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_CONTACT_ASSIGNMENTS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGN_HISTORY.CONTACT_ASSIGNMENT_ID | PN_CONTACT_ASSIGNMENTS_ALL |
PN.PN_CONTACT_ASSIGNMENTS_ALL does not reference any database object
PN.PN_CONTACT_ASSIGNMENTS_ALL is referenced by following:
| Description: | Track changes in contacts linked to the lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGN_HISTORY.COMPANY_ID | PN_COMPANIES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.COMPANY_SITE_ID | PN_COMPANY_SITES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.CONTACT_ASSIGNMENT_ID | PN_CONTACT_ASSIGNMENTS_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LOCATION_ID | PN_LOCATIONS_ALL |
PN.PN_CONTACT_ASSIGN_HISTORY does not reference any database object
PN.PN_CONTACT_ASSIGN_HISTORY is referenced by following:
| Description: | Information about currency_code and conversion_type |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CURRENCIES.CURRENCY_CODE | FND_CURRENCIES |
| PN_CURRENCIES.CONVERSION_TYPE | GL_DAILY_CONVERSION_TYPES |
PN.PN_CURRENCIES does not reference any database object
PN.PN_CURRENCIES is referenced by following:
| Description: | The table stores distributions for a payment term |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_DISTRIBUTIONS_ALL.ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_DISTRIBUTIONS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_DISTRIBUTIONS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_DISTRIBUTIONS_HISTORY.DISTRIBUTION_ID | PN_DISTRIBUTIONS_ALL |
PN.PN_DISTRIBUTIONS_ALL does not reference any database object
PN.PN_DISTRIBUTIONS_ALL is referenced by following:
| Description: | Distributions History Table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_DISTRIBUTIONS_HISTORY.DISTRIBUTION_ID | PN_DISTRIBUTIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_HISTORY.DISTRIBUTION_CHANGE_ID | PN_DISTRIBUTIONS_HISTORY |
PN.PN_DISTRIBUTIONS_HISTORY does not reference any database object
PN.PN_DISTRIBUTIONS_HISTORY is referenced by following:
| Description: | PN_EMP_SPACE_ASSIGN_ITF Interface Table. |
|---|
PN.PN_EMP_SPACE_ASSIGN_ITF does not reference any database object
PN.PN_EMP_SPACE_ASSIGN_ITF is referenced by following:
| Description: | This table has terms which have to excluded from the calculation of the Rent increase. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_EXCLUDE_TERM_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_EXCLUDE_TERM_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
PN.PN_INDEX_EXCLUDE_TERM_ALL does not reference any database object
PN.PN_INDEX_EXCLUDE_TERM_ALL is referenced by following:
| Description: | PN_INDEX_HISTORY_HEADERS stores index information. Indexes help to account for inflation when calculating rent increases |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_HISTORY_LINES.INDEX_ID | PN_INDEX_HISTORY_HEADERS |
| PN_INDEX_LEASES_ALL.INDEX_ID | PN_INDEX_HISTORY_HEADERS |
| PN_REC_AGR_LINCONST_ALL.CPI_INDEX | PN_INDEX_HISTORY_HEADERS |
PN.PN_INDEX_HISTORY_HEADERS does not reference any database object
PN.PN_INDEX_HISTORY_HEADERS is referenced by following:
| Description: | PN_INDEX_HISTORY_LINES stores all the relevant details associated with an Index type including index dates and index values. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_HISTORY_LINES.INDEX_ID | PN_INDEX_HISTORY_HEADERS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASES_ALL.BASE_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| PN_INDEX_LEASES_ALL.BASE_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| PN_INDEX_LEASE_PERIODS_ALL.CURRENT_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| PN_INDEX_LEASE_PERIODS_ALL.PREVIOUS_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
PN.PN_INDEX_HISTORY_LINES does not reference any database object
PN.PN_INDEX_HISTORY_LINES is referenced by following:
| Description: | PN_INDEX_LEASES_ALL stores all the rent increases associated with an existing lease. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASES_ALL.BASE_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| PN_INDEX_LEASES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_INDEX_LEASES_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_INDEX_LEASES_ALL.INDEX_ID | PN_INDEX_HISTORY_HEADERS |
| PN_INDEX_LEASES_ALL.BASE_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_EXCLUDE_TERM_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_LEASE_CONSTRAINTS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_LEASE_PERIODS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_LEASE_TERMS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
PN.PN_INDEX_LEASES_ALL does not reference any database object
PN.PN_INDEX_LEASES_ALL is referenced by following:
| Description: | PN_INDEX_LEASE_CONSTRAINTS_ALL stores the constraints that apply to the rent increase. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASE_CONSTRAINTS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
PN.PN_INDEX_LEASE_CONSTRAINTS_ALL does not reference any database object
PN.PN_INDEX_LEASE_CONSTRAINTS_ALL is referenced by following:
| Description: | PN_INDEX_LEASE_PERIODS_ALL stores the relevant details associated with all the rent increase periods. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASE_PERIODS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_LEASE_PERIODS_ALL.CURRENT_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| PN_INDEX_LEASE_PERIODS_ALL.PREVIOUS_INDEX_LINE_ID | PN_INDEX_HISTORY_LINES |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASE_TERMS_ALL.INDEX_PERIOD_ID | PN_INDEX_LEASE_PERIODS_ALL |
PN.PN_INDEX_LEASE_PERIODS_ALL does not reference any database object
PN.PN_INDEX_LEASE_PERIODS_ALL is referenced by following:
| Description: | This table stores the index payment terms. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INDEX_LEASE_TERMS_ALL.INDEX_LEASE_ID | PN_INDEX_LEASES_ALL |
| PN_INDEX_LEASE_TERMS_ALL.INDEX_PERIOD_ID | PN_INDEX_LEASE_PERIODS_ALL |
| PN_INDEX_LEASE_TERMS_ALL.LEASE_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_INDEX_LEASE_TERMS_ALL.RENT_INCREASE_TERM_ID | PN_PAYMENT_TERMS_ALL |
PN.PN_INDEX_LEASE_TERMS_ALL does not reference any database object
PN.PN_INDEX_LEASE_TERMS_ALL is referenced by following:
| Description: | Insurance details related to a lease. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INSURANCE_REQUIREMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_INSURANCE_REQUIREMENTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INSUR_REQUIRE_HISTORY.INSURANCE_REQUIREMENT_ID | PN_INSURANCE_REQUIREMENTS_ALL |
| PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID | PN_INSURANCE_REQUIREMENTS_ALL |
PN.PN_INSURANCE_REQUIREMENTS_ALL does not reference any database object
PN.PN_INSURANCE_REQUIREMENTS_ALL is referenced by following:
| Description: | Track changes to insurance details related to a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_INSUR_REQUIRE_HISTORY.INSURANCE_REQUIREMENT_ID | PN_INSURANCE_REQUIREMENTS_ALL |
| PN_INSUR_REQUIRE_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_INSUR_REQUIRE_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
PN.PN_INSUR_REQUIRE_HISTORY does not reference any database object
PN.PN_INSUR_REQUIRE_HISTORY is referenced by following:
| Description: | Information about the services provided by the landlord to the tenant. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LANDLORD_SERVICES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LANDLORD_SERVICES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LANDLORD_SERVICE_HISTORY.LANDLORD_SERVICE_ID | PN_LANDLORD_SERVICES_ALL |
PN.PN_LANDLORD_SERVICES_ALL does not reference any database object
PN.PN_LANDLORD_SERVICES_ALL is referenced by following:
| Description: | Track changes in the service provided by the landlord to the tenant |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LANDLORD_SERVICE_HISTORY.LANDLORD_SERVICE_ID | PN_LANDLORD_SERVICES_ALL |
| PN_LANDLORD_SERVICE_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_LANDLORD_SERVICE_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
PN.PN_LANDLORD_SERVICE_HISTORY does not reference any database object
PN.PN_LANDLORD_SERVICE_HISTORY is referenced by following:
| Description: | Lease information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASES_ALL.ABSTRACTED_BY_USER | FND_USER |
| PN_LEASES_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGNMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_INDEX_LEASES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_INSURANCE_REQUIREMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_INSUR_REQUIRE_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_LANDLORD_SERVICES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LANDLORD_SERVICE_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_REC_AGREEMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_CHANGES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_DETAILS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_DETAILS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_MILESTONES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_TRANSACTIONS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_NOTE_HEADERS.LEASE_ID | PN_LEASES_ALL |
| PN_OPTIONS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_OPTIONS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_PAYMENT_SCHEDULES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_PAYMENT_TERMS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_PAYMENT_TERMS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_REC_AGREEMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_ARCL_DTLLN_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_EXPCL_DTLLN_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_RIGHTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_RIGHTS_HISTORY.RIGHT_ID | PN_LEASES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_TENANCIES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_TENANCIES_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_VAR_RENTS_ALL.LEASE_ID | PN_LEASES_ALL |
PN.PN_LEASES_ALL does not reference any database object
PN.PN_LEASES_ALL is referenced by following:
| Description: | Lease abstracted, amended and edited |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_CHANGES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_CHANGES_ALL.LEASE_TRANSACTION_ID | PN_LEASE_TRANSACTIONS_ALL |
| PN_LEASE_CHANGES_ALL.ABSTRACTED_BY_USER | FND_USER |
| PN_LEASE_CHANGES_ALL.RESPONSIBLE_USER | FND_USER |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGNMENTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_INSURANCE_REQUIREMENTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_INSUR_REQUIRE_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LANDLORD_SERVICES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LANDLORD_SERVICE_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_DETAILS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_DETAILS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_MILESTONES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_OPTIONS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_OPTIONS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_SCHEDULES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_TERMS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_TERMS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_RIGHTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_RIGHTS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_RIGHTS_HISTORY.NEW_LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_TENANCIES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_TENANCIES_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
PN.PN_LEASE_CHANGES_ALL does not reference any database object
PN.PN_LEASE_CHANGES_ALL is referenced by following:
| Description: | Lease dates and accounting information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_DETAILS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_DETAILS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_DETAILS_ALL.EXPENSE_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_LEASE_DETAILS_ALL.RESPONSIBLE_USER | FND_USER |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_DETAILS_HISTORY.LEASE_DETAIL_ID | PN_LEASE_DETAILS_ALL |
PN.PN_LEASE_DETAILS_ALL does not reference any database object
PN.PN_LEASE_DETAILS_ALL is referenced by following:
| Description: | Track changes to the lease details data elements |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_DETAILS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_DETAILS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_DETAILS_HISTORY.LEASE_DETAIL_ID | PN_LEASE_DETAILS_ALL |
| PN_LEASE_DETAILS_HISTORY.RESPONSIBLE_USER | FND_USER |
| PN_LEASE_DETAILS_HISTORY.EXPENSE_ACCOUNT_ID | GL_CODE_COMBINATIONS |
PN.PN_LEASE_DETAILS_HISTORY does not reference any database object
PN.PN_LEASE_DETAILS_HISTORY is referenced by following:
| Description: | Information about important events in a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_MILESTONES_ALL.INSURANCE_REQUIREMENT_ID | PN_INSURANCE_REQUIREMENTS_ALL |
| PN_LEASE_MILESTONES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_MILESTONES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_LEASE_MILESTONES_ALL.OPTION_ID | PN_OPTIONS_ALL |
| PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
PN.PN_LEASE_MILESTONES_ALL does not reference any database object
PN.PN_LEASE_MILESTONES_ALL is referenced by following:
| Description: | PN_LEASE_OPTIONS_ITF Interface Table. |
|---|
PN.PN_LEASE_OPTIONS_ITF does not reference any database object
PN.PN_LEASE_OPTIONS_ITF is referenced by following:
| Description: | Transactions performed on a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_TRANSACTIONS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_LEASE_TRANSACTIONS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_CHANGES_ALL.LEASE_TRANSACTION_ID | PN_LEASE_TRANSACTIONS_ALL |
PN.PN_LEASE_TRANSACTIONS_ALL does not reference any database object
PN.PN_LEASE_TRANSACTIONS_ALL is referenced by following:
| Description: | Space definition |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOCATIONS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_LOCATIONS_ALL.ADDRESS_ID | PN_ADDRESSES_ALL |
| PN_LOCATIONS_ALL.PARENT_LOCATION_ID | PN_LOCATIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_CONTACT_ASSIGNMENTS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_CONTACT_ASSIGN_HISTORY.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_LEASE_TRANSACTIONS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_LOCATIONS_ALL.PARENT_LOCATION_ID | PN_LOCATIONS_ALL |
| PN_LOCATION_FEATURES_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_SPACE_ALLOCATIONS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_TENANCIES_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_TENANCIES_HISTORY.LOCATION_ID | PN_LOCATIONS_ALL |
PN.PN_LOCATIONS_ALL does not reference any database object
PN.PN_LOCATIONS_ALL is referenced by following:
| Description: | Space definition data to be imported or exported in and out of Oracle Property Manager |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOCATIONS_ITF.PROPERTY_ID | PN_PROPERTIES_ALL |
PN.PN_LOCATIONS_ITF does not reference any database object
PN.PN_LOCATIONS_ITF is referenced by following:
| Description: | Information on features available in a building |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOCATION_FEATURES_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
PN.PN_LOCATION_FEATURES_ALL does not reference any database object
PN.PN_LOCATION_FEATURES_ALL is referenced by following:
| Description: | Information on Regions and Office Parks |
|---|
PN.PN_LOCATION_PARKS does not reference any database object
PN.PN_LOCATION_PARKS is referenced by following:
| Description: | Stores the information for mapping of expense accounts to the location. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOC_ACC_MAP_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_LOC_ACC_MAP_ALL.LOC_ACC_MAP_HDR_ID | PN_LOC_ACC_MAP_HDR_ALL |
PN.PN_LOC_ACC_MAP_ALL does not reference any database object
PN.PN_LOC_ACC_MAP_ALL is referenced by following:
| Description: | Stores mapping accounts to location header information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOC_ACC_MAP_HDR_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOC_ACC_MAP_ALL.LOC_ACC_MAP_HDR_ID | PN_LOC_ACC_MAP_HDR_ALL |
PN.PN_LOC_ACC_MAP_HDR_ALL does not reference any database object
PN.PN_LOC_ACC_MAP_HDR_ALL is referenced by following:
| Description: | PN_MILESTONES_ITF Interface Table. |
|---|
PN.PN_MILESTONES_ITF does not reference any database object
PN.PN_MILESTONES_ITF is referenced by following:
| Description: | Multiple lines of text associated with a note type. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_NOTE_DETAILS.NOTE_HEADER_ID | PN_NOTE_HEADERS |
PN.PN_NOTE_DETAILS does not reference any database object
PN.PN_NOTE_DETAILS is referenced by following:
| Description: | Type of note in a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_NOTE_HEADERS.LEASE_ID | PN_LEASES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_NOTE_DETAILS.NOTE_HEADER_ID | PN_NOTE_HEADERS |
PN.PN_NOTE_HEADERS does not reference any database object
PN.PN_NOTE_HEADERS is referenced by following:
| Description: | This table stores method and overview information for operating expense agreements. |
|---|
PN.PN_OPEX_AGREEMENTS_ALL does not reference any database object
PN.PN_OPEX_AGREEMENTS_ALL is referenced by following:
| Description: | This table stores information on critical dates for operating expense agreements. |
|---|
PN.PN_OPEX_CRITICAL_DATES_ALL does not reference any database object
PN.PN_OPEX_CRITICAL_DATES_ALL is referenced by following:
| Description: | This table stores estimated payment information for operating expense agreements. |
|---|
PN.PN_OPEX_EST_PAYMENTS_ALL does not reference any database object
PN.PN_OPEX_EST_PAYMENTS_ALL is referenced by following:
| Description: | This table stores expense group information for operating expense agreements. |
|---|
PN.PN_OPEX_EXP_GRPS_ALL does not reference any database object
PN.PN_OPEX_EXP_GRPS_ALL is referenced by following:
| Description: | This table stores the information related to the 'Notes' section on various sub tabs in an Opex Agreement. |
|---|
PN.PN_OPEX_NOTES_ALL does not reference any database object
PN.PN_OPEX_NOTES_ALL is referenced by following:
| Description: | This table stores pro rata basis information for operating expense agreeements. |
|---|
PN.PN_OPEX_PRORAT_BASIS_DTLS_ALL does not reference any database object
PN.PN_OPEX_PRORAT_BASIS_DTLS_ALL is referenced by following:
| Description: | This table stores reconciliation overview information for operating expenses |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_ALL.OPEX_RECON_ID | PN_OPEX_RECON_ALL |
PN.PN_OPEX_RECON_ALL does not reference any database object
PN.PN_OPEX_RECON_ALL is referenced by following:
| Description: | This table stores information on critical dates for operating expense reconciliations |
|---|
PN.PN_OPEX_RECON_CRDT_ALL does not reference any database object
PN.PN_OPEX_RECON_CRDT_ALL is referenced by following:
| Description: | This table stores reconciliation review information for operating expenses |
|---|
PN.PN_OPEX_RECON_DETAILS_ALL does not reference any database object
PN.PN_OPEX_RECON_DETAILS_ALL is referenced by following:
| Description: | This table stores expense group information for operating expense reconciliations |
|---|
PN.PN_OPEX_RECON_EXP_GRP_ALL does not reference any database object
PN.PN_OPEX_RECON_EXP_GRP_ALL is referenced by following:
| Description: | This table stores pro rata basis information for operating expense reconciliations |
|---|
PN.PN_OPEX_RECON_PRTBS_ALL does not reference any database object
PN.PN_OPEX_RECON_PRTBS_ALL is referenced by following:
| Description: | Details of specified terms for a specific period in a lease contract |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_OPTIONS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_OPTIONS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LEASE_MILESTONES_ALL.OPTION_ID | PN_OPTIONS_ALL |
| PN_OPTIONS_HISTORY.OPTION_ID | PN_OPTIONS_ALL |
PN.PN_OPTIONS_ALL does not reference any database object
PN.PN_OPTIONS_ALL is referenced by following:
| Description: | Track changes in option details related to a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_OPTIONS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_OPTIONS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_OPTIONS_HISTORY.OPTION_ID | PN_OPTIONS_ALL |
PN.PN_OPTIONS_HISTORY does not reference any database object
PN.PN_OPTIONS_HISTORY is referenced by following:
| Description: | Payment and billing items associated with a payment or a billing schedule |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_PAYMENT_ITEMS_ALL.PAYMENT_SCHEDULE_ID | PN_PAYMENT_SCHEDULES_ALL |
| PN_PAYMENT_ITEMS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_PAYMENT_ITEMS_ALL.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS_11I |
| PN_PAYMENT_ITEMS_ALL.CURRENCY_CODE | FND_CURRENCIES |
| PN_PAYMENT_ITEMS_ALL.EXPORT_CURRENCY_CODE | FND_CURRENCIES |
| PN_PAYMENT_ITEMS_ALL.VENDOR_ID | PO_VENDORS |
| PN_PAYMENT_ITEMS_ALL.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID | RA_SITE_USES_ALL |
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_PAYMENT_ITEMS_ALL.CUST_SHIP_SITE_ID | HZ_CUST_SITE_USES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_DETAILS.PAYMENT_ITEM_ID | PN_PAYMENT_ITEMS_ALL |
PN.PN_PAYMENT_ITEMS_ALL does not reference any database object
PN.PN_PAYMENT_ITEMS_ALL is referenced by following:
| Description: | Shadow table for PN_PAYMENT_ITEMS_ALL for supporting Euro functional currency |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_ITEMS_EFC.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_ITEMS_EFC.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
PN.PN_PAYMENT_ITEMS_EFC does not reference any database object
PN.PN_PAYMENT_ITEMS_EFC is referenced by following:
| Description: | Payment or billing schedules for both landlord and the tenant |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_SCHEDULES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_PAYMENT_SCHEDULES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_SCHEDULES_ALL.APPROVED_BY_USER_ID | FND_USER |
| PN_PAYMENT_SCHEDULES_ALL.TRANSFERRED_BY_USER_ID | FND_USER |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_ITEMS_ALL.PAYMENT_SCHEDULE_ID | PN_PAYMENT_SCHEDULES_ALL |
PN.PN_PAYMENT_SCHEDULES_ALL does not reference any database object
PN.PN_PAYMENT_SCHEDULES_ALL is referenced by following:
| Description: | Payment and billing terms defined in a lease |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_PAYMENT_TERMS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_PAYMENT_TERMS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_TERMS_ALL.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS_11I |
| PN_PAYMENT_TERMS_ALL.CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
| PN_PAYMENT_TERMS_ALL.CURRENCY_CODE | FND_CURRENCIES |
| PN_PAYMENT_TERMS_ALL.VENDOR_ID | PO_VENDORS |
| PN_PAYMENT_TERMS_ALL.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
| PN_PAYMENT_TERMS_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID | RA_SITE_USES_ALL |
| PN_PAYMENT_TERMS_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_PAYMENT_TERMS_ALL.CUST_SHIP_SITE_ID | HZ_CUST_SITE_USES_ALL |
| PN_PAYMENT_TERMS_ALL.PERIOD_BILLREC_ID | PN_REC_PERIOD_BILL_ALL |
| PN_PAYMENT_TERMS_ALL.OPEX_RECON_ID | PN_OPEX_RECON_ALL |
| PN_PAYMENT_TERMS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
| PN_PAYMENT_TERMS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_SUMMARIES.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_INDEX_EXCLUDE_TERM_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_INDEX_LEASE_TERMS_ALL.LEASE_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_INDEX_LEASE_TERMS_ALL.RENT_INCREASE_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_PAYMENT_ITEMS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_REC_LINBILL_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_PAYMENT_TERMS_HISTORY.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_REC_LINBILL_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
PN.PN_PAYMENT_TERMS_ALL does not reference any database object
PN.PN_PAYMENT_TERMS_ALL is referenced by following:
| Description: | Shadow table for PN_PAYMENT_TERMS_ALL for supporting Euro functional currency. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_EFC.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_PAYMENT_TERMS_EFC.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
PN.PN_PAYMENT_TERMS_EFC does not reference any database object
PN.PN_PAYMENT_TERMS_EFC is referenced by following:
| Description: | Term History table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_HISTORY.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_PAYMENT_TERMS_HISTORY.DISTRIBUTION_CHANGE_ID | PN_DISTRIBUTIONS_HISTORY |
| PN_PAYMENT_TERMS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_PAYMENT_TERMS_HISTORY.LEASE_ID | PN_LEASES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_ADJUSTMENT_DETAILS.TERM_HISTORY_ID | PN_PAYMENT_TERMS_HISTORY |
PN.PN_PAYMENT_TERMS_HISTORY does not reference any database object
PN.PN_PAYMENT_TERMS_HISTORY is referenced by following:
| Description: | Stores Group By information. |
|---|
PN.PN_PAY_GROUP_BYS does not reference any database object
PN.PN_PAY_GROUP_BYS is referenced by following:
| Description: | Stores grouping rules information. |
|---|
PN.PN_PAY_GROUP_RULES does not reference any database object
PN.PN_PAY_GROUP_RULES is referenced by following:
| Description: | Telecommuting information to reach a contact |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PHONES_ALL.CONTACT_ID | PN_CONTACTS_ALL |
PN.PN_PHONES_ALL does not reference any database object
PN.PN_PHONES_ALL is referenced by following:
| Description: | Stores the properties information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_LOCATIONS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_LOCATIONS_ITF.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_AGREEMENTS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXPCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_ITF.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_ARCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_AGREEMENTS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_ARCL_DTLLN_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_ARCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXPCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
PN.PN_PROPERTIES_ALL does not reference any database object
PN.PN_PROPERTIES_ALL is referenced by following:
| Description: | Recovery Agreement set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGREEMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_AGREEMENTS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_AGREEMENTS_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGREEMENTS_ALL.CUSTOMER_ID | HZ_PARTIES |
| PN_REC_AGREEMENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_AGREEMENTS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_REC_AGREEMENTS_ALL.CUST_SITE_ID | HZ_CUST_SITE_USES_ALL |
| PN_REC_AGREEMENTS_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_AGREEMENTS_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
PN.PN_REC_AGREEMENTS_ALL does not reference any database object
PN.PN_REC_AGREEMENTS_ALL is referenced by following:
| Description: | Recovery Abatement set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINABAT_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGR_LINABAT_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINABAT_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
PN.PN_REC_AGR_LINABAT_ALL does not reference any database object
PN.PN_REC_AGR_LINABAT_ALL is referenced by following:
| Description: | Recovery Area set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINAREA_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGR_LINAREA_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINAREA_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_AGR_LINAREA_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINAREA_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
PN.PN_REC_AGR_LINAREA_ALL does not reference any database object
PN.PN_REC_AGR_LINAREA_ALL is referenced by following:
| Description: | Recovery Constraint set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINCONST_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGR_LINCONST_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINCONST_ALL.CPI_INDEX | PN_INDEX_HISTORY_HEADERS |
| PN_REC_AGR_LINCONST_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
PN.PN_REC_AGR_LINCONST_ALL does not reference any database object
PN.PN_REC_AGR_LINCONST_ALL is referenced by following:
| Description: | Recovery Lines set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINES_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_AGR_LINES_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINABAT_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINAREA_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINCONST_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINAREA_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINEXP_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINCONST_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINABAT_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINEXP_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
PN.PN_REC_AGR_LINES_ALL does not reference any database object
PN.PN_REC_AGR_LINES_ALL is referenced by following:
| Description: | Recovery Expense set up table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINEXP_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINEXP_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_AGR_LINEXP_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_AGR_LINEXP_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_AGR_LINEXP_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
PN.PN_REC_AGR_LINEXP_ALL does not reference any database object
PN.PN_REC_AGR_LINEXP_ALL is referenced by following:
| Description: | Stores area class header information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_ARCL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_ARCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINAREA_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_DTL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_EXC_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_DTL_ALL.DEFAULT_AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_EXC_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_DTL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_AGR_LINAREA_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_DTL_ALL.DEFAULT_AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
PN.PN_REC_ARCL_ALL does not reference any database object
PN.PN_REC_ARCL_ALL is referenced by following:
| Description: | Stores drilldown information associated with an area class detail |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_DTLLN_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_ARCL_DTLLN_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_ARCL_DTLLN_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_ARCL_DTLLN_ALL.AREA_CLASS_DTL_ID | PN_REC_ARCL_DTL_ALL |
| PN_REC_ARCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_ARCL_DTLLN_ALL.CUST_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_REC_ARCL_DTLLN_ALL.AREA_CLASS_DTL_ID | PN_REC_ARCL_DTL_ALL |
| PN_REC_ARCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
PN.PN_REC_ARCL_DTLLN_ALL does not reference any database object
PN.PN_REC_ARCL_DTLLN_ALL is referenced by following:
| Description: | Stores area class details summary header information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_DTL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_DTL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_ARCL_DTL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_DTLLN_ALL.AREA_CLASS_DTL_ID | PN_REC_ARCL_DTL_ALL |
| PN_REC_ARCL_DTLLN_ALL.AREA_CLASS_DTL_ID | PN_REC_ARCL_DTL_ALL |
PN.PN_REC_ARCL_DTL_ALL does not reference any database object
PN.PN_REC_ARCL_DTL_ALL is referenced by following:
| Description: | Stores area class exclusions information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_EXC_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_ARCL_EXC_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_ARCL_EXC_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
PN.PN_REC_ARCL_EXC_ALL does not reference any database object
PN.PN_REC_ARCL_EXC_ALL is referenced by following:
| Description: | Calculation Periods table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_CALC_PERIODS_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_CALC_PERIODS_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_PERIOD_BILL_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
PN.PN_REC_CALC_PERIODS_ALL does not reference any database object
PN.PN_REC_CALC_PERIODS_ALL is referenced by following:
| Description: | Stores expense class setup information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXPCL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXPCL_ALL.AREA_CLASS_ID | PN_REC_ARCL_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_AGR_LINEXP_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_TYPE_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_AGR_LINEXP_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_TYPE_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
PN.PN_REC_EXPCL_ALL does not reference any database object
PN.PN_REC_EXPCL_ALL is referenced by following:
| Description: | Stores drilldown information associated with an expense class line detail. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTLACC_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_CLASS_LINE_ID | PN_REC_EXPCL_DTLLN_ALL |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_CLASS_LINE_ID | PN_REC_EXPCL_DTLLN_ALL |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
PN.PN_REC_EXPCL_DTLACC_ALL does not reference any database object
PN.PN_REC_EXPCL_DTLACC_ALL is referenced by following:
| Description: | Stores expense class line details associated with a summary header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTLLN_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_DTLLN_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_CLASS_LINE_ID | PN_REC_EXPCL_DTLLN_ALL |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_CLASS_LINE_ID | PN_REC_EXPCL_DTLLN_ALL |
PN.PN_REC_EXPCL_DTLLN_ALL does not reference any database object
PN.PN_REC_EXPCL_DTLLN_ALL is referenced by following:
| Description: | Stores expense class details header information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTL_ALL.DEFAULT_AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_DTL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
| PN_REC_EXPCL_DTL_ALL.DEFAULT_AREA_CLASS_ID | PN_REC_ARCL_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
| PN_REC_EXPCL_DTLLN_ALL.EXPENSE_CLASS_DTL_ID | PN_REC_EXPCL_DTL_ALL |
PN.PN_REC_EXPCL_DTL_ALL does not reference any database object
PN.PN_REC_EXPCL_DTL_ALL is referenced by following:
| Description: | Stores expense class inclusions associated with an expense class |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_INC_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_INC_ALL.EXPENSE_CLASS_TYPE_ID | PN_REC_EXPCL_TYPE_ALL |
| PN_REC_EXPCL_INC_ALL.EXPENSE_CLASS_TYPE_ID | PN_REC_EXPCL_TYPE_ALL |
PN.PN_REC_EXPCL_INC_ALL does not reference any database object
PN.PN_REC_EXPCL_INC_ALL is referenced by following:
| Description: | Stores expense class types associated with an expense class |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_TYPE_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| PN_REC_EXPCL_TYPE_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXPCL_TYPE_ALL.EXPENSE_CLASS_ID | PN_REC_EXPCL_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_INC_ALL.EXPENSE_CLASS_TYPE_ID | PN_REC_EXPCL_TYPE_ALL |
| PN_REC_EXPCL_INC_ALL.EXPENSE_CLASS_TYPE_ID | PN_REC_EXPCL_TYPE_ALL |
PN.PN_REC_EXPCL_TYPE_ALL does not reference any database object
PN.PN_REC_EXPCL_TYPE_ALL is referenced by following:
| Description: | Recovery Expense Interface Table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXP_ITF.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_ITF.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
PN.PN_REC_EXP_ITF does not reference any database object
PN.PN_REC_EXP_ITF is referenced by following:
| Description: | Stores the expense lines header information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXP_LINE_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXP_LINE_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXPCL_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
| PN_REC_EXP_LINE_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
| PN_REC_EXPCL_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
PN.PN_REC_EXP_LINE_ALL does not reference any database object
PN.PN_REC_EXP_LINE_ALL is referenced by following:
| Description: | Stores recovery expense lines and recovery expense line allocations information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| PN_REC_EXP_LINE_DTL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_REC_EXP_LINE_DTL_ALL.EXPENSE_LINE_ID | PN_REC_EXP_LINE_ALL |
| PN_REC_EXP_LINE_DTL_ALL.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
| PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID | PN_PROPERTIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_EXP_ITF.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
| PN_REC_EXPCL_DTLACC_ALL.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
| PN_REC_EXP_LINE_DTL_ALL.EXPENSE_LINE_DTL_ID | PN_REC_EXP_LINE_DTL_ALL |
PN.PN_REC_EXP_LINE_DTL_ALL does not reference any database object
PN.PN_REC_EXP_LINE_DTL_ALL is referenced by following:
| Description: | Calculation Periods table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_LINBILL_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_LINBILL_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_REC_LINBILL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
PN.PN_REC_LINBILL_ALL does not reference any database object
PN.PN_REC_LINBILL_ALL is referenced by following:
| Description: | Billed terms for a period and line table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGREEMENT_ID | PN_REC_AGREEMENTS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_BILL_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_BILL_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_PAYMENT_TERMS_ALL.PERIOD_BILLREC_ID | PN_REC_PERIOD_BILL_ALL |
PN.PN_REC_PERIOD_BILL_ALL does not reference any database object
PN.PN_REC_PERIOD_BILL_ALL is referenced by following:
| Description: | Recovery lines and the amount calculated for a period |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_PERIOD_LINES_ALL.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
| PN_REC_PERIOD_LINES_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_AGR_LINE_ID | PN_REC_AGR_LINES_ALL |
| PN_REC_PERIOD_LINES_ALL.REC_CALC_PERIOD_ID | PN_REC_CALC_PERIODS_ALL |
| PN_REC_PERIOD_LINES_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
PN.PN_REC_PERIOD_LINES_ALL does not reference any database object
PN.PN_REC_PERIOD_LINES_ALL is referenced by following:
| Description: | This table is used to create the RXi Rent Increase Account Detail Report |
|---|
PN.PN_RENT_INCREASE_DETAILACC_ITF does not reference any database object
PN.PN_RENT_INCREASE_DETAILACC_ITF is referenced by following:
| Description: | This table is used to create the RXi Rent Increase Detail Report |
|---|
PN.PN_RENT_INCREASE_DETAIL_ITF does not reference any database object
PN.PN_RENT_INCREASE_DETAIL_ITF is referenced by following:
| Description: | This table is used to create the RXi Rent Increase Summary Report |
|---|
PN.PN_RENT_INCREASE_SUMMARY_ITF does not reference any database object
PN.PN_RENT_INCREASE_SUMMARY_ITF is referenced by following:
| Description: | PN_RENT_ROLL_LEASE_EXP_ITF Interface Table. |
|---|
PN.PN_RENT_ROLL_LEASE_EXP_ITF does not reference any database object
PN.PN_RENT_ROLL_LEASE_EXP_ITF is referenced by following:
| Description: | Stores the rights information for leases |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_RIGHTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_RIGHTS_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_RIGHTS_HISTORY.RIGHT_ID | PN_RIGHTS_ALL |
PN.PN_RIGHTS_ALL does not reference any database object
PN.PN_RIGHTS_ALL is referenced by following:
| Description: | Stores the rights history for lease amendments |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_RIGHTS_HISTORY.RIGHT_ID | PN_LEASES_ALL |
| PN_RIGHTS_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_RIGHTS_HISTORY.NEW_LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_RIGHTS_HISTORY.RIGHT_ID | PN_RIGHTS_ALL |
PN.PN_RIGHTS_HISTORY does not reference any database object
PN.PN_RIGHTS_HISTORY is referenced by following:
| Description: | Milestone setup information to be associated with a milestone set |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SET_MILESTONES.SET_ID | PN_SET_TYPES |
PN.PN_SET_MILESTONES does not reference any database object
PN.PN_SET_MILESTONES is referenced by following:
| Description: | Type of milestones grouping |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SET_MILESTONES.SET_ID | PN_SET_TYPES |
PN.PN_SET_TYPES does not reference any database object
PN.PN_SET_TYPES is referenced by following:
| Description: | Space assignment information for an employee, contractor or the cost center. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SPACE_ALLOCATIONS_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
PN.PN_SPACE_ALLOCATIONS_ALL does not reference any database object
PN.PN_SPACE_ALLOCATIONS_ALL is referenced by following:
| Description: | No Longer Used |
|---|
PN.PN_SPACE_ALLOC_ITF does not reference any database object
PN.PN_SPACE_ALLOC_ITF is referenced by following:
| Description: | Stores the customer space assignment information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SPACE_ASSIGN_CUST_ALL.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
| PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID | PN_TENANCIES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
| PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.EXPENSE_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_SPACE_ASSIGN_CUST_ALL.PROJECT_ID | PA_PROJECTS_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.TASK_ID | PA_TASKS |
| PN_SPACE_ASSIGN_CUST_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID | PN_TENANCIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_REC_ARCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_ARCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
| PN_REC_EXPCL_DTLLN_ALL.CUST_SPACE_ASSIGN_ID | PN_SPACE_ASSIGN_CUST_ALL |
PN.PN_SPACE_ASSIGN_CUST_ALL does not reference any database object
PN.PN_SPACE_ASSIGN_CUST_ALL is referenced by following:
| Description: | Stores the employee space assignment information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SPACE_ASSIGN_EMP_ALL.PROJECT_ID | PA_PROJECTS_ALL |
| PN_SPACE_ASSIGN_EMP_ALL.TASK_ID | PA_TASKS |
PN.PN_SPACE_ASSIGN_EMP_ALL does not reference any database object
PN.PN_SPACE_ASSIGN_EMP_ALL is referenced by following:
| Description: | PN_SPACE_ASSIGN_LEASE_ITF Interface Table. |
|---|
PN.PN_SPACE_ASSIGN_LEASE_ITF does not reference any database object
PN.PN_SPACE_ASSIGN_LEASE_ITF is referenced by following:
| Description: | PN_SPACE_ASSIGN_LOC_ITF Interface Table. |
|---|
PN.PN_SPACE_ASSIGN_LOC_ITF does not reference any database object
PN.PN_SPACE_ASSIGN_LOC_ITF is referenced by following:
| Description: | PN_SPACE_UTIL_LEASE_ITF Interface Table. |
|---|
PN.PN_SPACE_UTIL_LEASE_ITF does not reference any database object
PN.PN_SPACE_UTIL_LEASE_ITF is referenced by following:
| Description: | PN_SPACE_UTIL_LOC_ITF Interface Table. |
|---|
PN.PN_SPACE_UTIL_LOC_ITF does not reference any database object
PN.PN_SPACE_UTIL_LOC_ITF is referenced by following:
| Description: | Property Manager system setup options for operating units. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SYSTEM_SETUP_OPTIONS.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
| PN_SYSTEM_SETUP_OPTIONS.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS_11I |
PN.PN_SYSTEM_SETUP_OPTIONS does not reference any database object
PN.PN_SYSTEM_SETUP_OPTIONS is referenced by following:
| Description: | Information on leased or subleased locations |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_TENANCIES_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_TENANCIES_ALL.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_TENANCIES_ALL.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_TENANCIES_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_TENANCIES_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID | PN_TENANCIES_ALL |
| PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID | PN_TENANCIES_ALL |
| PN_TENANCIES_HISTORY.TENANCY_ID | PN_TENANCIES_ALL |
PN.PN_TENANCIES_ALL does not reference any database object
PN.PN_TENANCIES_ALL is referenced by following:
| Description: | Track changes in the leased or subleased locations |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_TENANCIES_HISTORY.LEASE_ID | PN_LEASES_ALL |
| PN_TENANCIES_HISTORY.LEASE_CHANGE_ID | PN_LEASE_CHANGES_ALL |
| PN_TENANCIES_HISTORY.LOCATION_ID | PN_LOCATIONS_ALL |
| PN_TENANCIES_HISTORY.TENANCY_ID | PN_TENANCIES_ALL |
| PN_TENANCIES_HISTORY.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
PN.PN_TENANCIES_HISTORY does not reference any database object
PN.PN_TENANCIES_HISTORY is referenced by following:
| Description: | PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_TERM_TEMPLATES_ALL.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS_11I |
| PN_TERM_TEMPLATES_ALL.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
| PN_TERM_TEMPLATES_ALL.CUSTOMER_SITE_USE_ID | HZ_CUST_SITE_USES_ALL |
| PN_TERM_TEMPLATES_ALL.CUST_SHIP_SITE_ID | HZ_CUST_SITE_USES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_DISTRIBUTIONS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_INDEX_LEASES_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_REC_AGREEMENTS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_DISTRIBUTIONS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_VAR_RENTS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| PN_PAYMENT_TERMS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
PN.PN_TERM_TEMPLATES_ALL does not reference any database object
PN.PN_TERM_TEMPLATES_ALL is referenced by following:
| Description: | Stores recurring abatements information for an invoice. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
| PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID | PN_PAYMENT_TERMS_ALL |
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
PN.PN_VAR_ABATEMENTS_ALL does not reference any database object
PN.PN_VAR_ABATEMENTS_ALL is referenced by following:
| Description: | This table stores setup information for abatements and allowances. |
|---|
PN.PN_VAR_ABAT_DEFAULTS_ALL does not reference any database object
PN.PN_VAR_ABAT_DEFAULTS_ALL is referenced by following:
| Description: | This table stores setup information for breakpoint details by organization. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_DET_ALL.BKDT_DEFAULT_ID | PN_VAR_BKDT_DEFAULTS_ALL |
PN.PN_VAR_BKDT_DEFAULTS_ALL does not reference any database object
PN.PN_VAR_BKDT_DEFAULTS_ALL is referenced by following:
| Description: | This table stores setup information for breakpoints by organization. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_HEAD_ALL.BKHD_DEFAULT_ID | PN_VAR_BKHD_DEFAULTS_ALL |
PN.PN_VAR_BKHD_DEFAULTS_ALL does not reference any database object
PN.PN_VAR_BKHD_DEFAULTS_ALL is referenced by following:
| Description: | Stores breakpoint related information to be used in the calculation of variable rent for each line item. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_DET_ALL.BKPT_HEADER_ID | PN_VAR_BKPTS_HEAD_ALL |
| PN_VAR_BKPTS_DET_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_BKPTS_DET_ALL.BKDT_DEFAULT_ID | PN_VAR_BKDT_DEFAULTS_ALL |
| PN_VAR_BKPTS_DET_ALL.BKPT_HEADER_ID | PN_VAR_BKPTS_HEAD_ALL |
PN.PN_VAR_BKPTS_DET_ALL does not reference any database object
PN.PN_VAR_BKPTS_DET_ALL is referenced by following:
| Description: | Stores breakpoint related detail information to be used in the calculation of variable rent for each line item. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_HEAD_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_BKPTS_HEAD_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_BKPTS_HEAD_ALL.BKHD_DEFAULT_ID | PN_VAR_BKHD_DEFAULTS_ALL |
| PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_DET_ALL.BKPT_HEADER_ID | PN_VAR_BKPTS_HEAD_ALL |
| PN_VAR_BKPTS_DET_ALL.BKPT_HEADER_ID | PN_VAR_BKPTS_HEAD_ALL |
PN.PN_VAR_BKPTS_HEAD_ALL does not reference any database object
PN.PN_VAR_BKPTS_HEAD_ALL is referenced by following:
| Description: | Stores constraints to be applied to a period for the calculation of variable rent. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_CONSTRAINTS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_CONSTRAINTS_ALL.CONSTR_TEMPLATE_ID | PN_VAR_CONSTR_TEMPLATES_ALL |
| PN_VAR_CONSTRAINTS_ALL.CONSTR_DEFAULT_ID | PN_VAR_CONSTR_DEFAULTS_ALL |
| PN_VAR_CONSTRAINTS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_CONSTRAINTS_ALL.AGREEMENT_TEMPLATE_ID | PN_VAR_TEMPLATES_ALL |
PN.PN_VAR_CONSTRAINTS_ALL does not reference any database object
PN.PN_VAR_CONSTRAINTS_ALL is referenced by following:
| Description: | This table stores setup information for constraints by organization. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_CONSTRAINTS_ALL.CONSTR_DEFAULT_ID | PN_VAR_CONSTR_DEFAULTS_ALL |
PN.PN_VAR_CONSTR_DEFAULTS_ALL does not reference any database object
PN.PN_VAR_CONSTR_DEFAULTS_ALL is referenced by following:
| Description: | Constraints Templates |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_CONSTRAINTS_ALL.CONSTR_TEMPLATE_ID | PN_VAR_CONSTR_TEMPLATES_ALL |
PN.PN_VAR_CONSTR_TEMPLATES_ALL does not reference any database object
PN.PN_VAR_CONSTR_TEMPLATES_ALL is referenced by following:
| Description: | Stores deductions to be applied to each line item for calculation of variable rent. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_DEDUCTIONS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_DEDUCTIONS_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_DEDUCTIONS_ALL.GL_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
PN.PN_VAR_DEDUCTIONS_ALL does not reference any database object
PN.PN_VAR_DEDUCTIONS_ALL is referenced by following:
| Description: | This table stores deduction data that was modified during batch import. |
|---|
PN.PN_VAR_DEDUCT_ARCH_ALL does not reference any database object
PN.PN_VAR_DEDUCT_ARCH_ALL is referenced by following:
| Description: | Stores critical dates related to the variable rent agreement generated by the periods generation program. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_GRP_DATES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_GRP_DATES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_GRP_DATES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_DEDUCTIONS_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_VOL_HIST_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_RENT_SUMM_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_RENT_SUMM_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_VOL_HIST_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
PN.PN_VAR_GRP_DATES_ALL does not reference any database object
PN.PN_VAR_GRP_DATES_ALL is referenced by following:
| Description: | Stores information related to line items associated within each period for a variable rent. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_LINES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_LINES_ALL.LINE_TEMPLATE_ID | PN_VAR_LINE_TEMPLATES_ALL |
| PN_VAR_LINES_ALL.AGREEMENT_TEMPLATE_ID | PN_VAR_TEMPLATES_ALL |
| PN_VAR_LINES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_LINES_ALL.LINE_TEMPLATE_ID | PN_VAR_LINE_TEMPLATES_ALL |
| PN_VAR_LINES_ALL.LINE_DEFAULT_ID | PN_VAR_LINE_DEFAULTS_ALL |
| PN_VAR_LINES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
PN.PN_VAR_LINES_ALL does not reference any database object
PN.PN_VAR_LINES_ALL is referenced by following:
| Description: | This table stores default line setup information for variable rent by organization. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_LINES_ALL.LINE_DEFAULT_ID | PN_VAR_LINE_DEFAULTS_ALL |
PN.PN_VAR_LINE_DEFAULTS_ALL does not reference any database object
PN.PN_VAR_LINE_DEFAULTS_ALL is referenced by following:
| Description: | This table stores line setup information for variable rent by organization. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_LINES_ALL.LINE_TEMPLATE_ID | PN_VAR_LINE_TEMPLATES_ALL |
| PN_VAR_LINES_ALL.LINE_TEMPLATE_ID | PN_VAR_LINE_TEMPLATES_ALL |
PN.PN_VAR_LINE_TEMPLATES_ALL does not reference any database object
PN.PN_VAR_LINE_TEMPLATES_ALL is referenced by following:
| Description: | Stores information about periods generated by the periods generation program for the duration of variable rent. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_PERIODS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_PERIODS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_BKPTS_HEAD_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_CONSTRAINTS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_DEDUCTIONS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_GRP_DATES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_LINES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_GRP_DATES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_CONSTRAINTS_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_RENT_INV_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_LINES_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_RENT_INV_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_RENT_SUMM_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_VOL_HIST_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
PN.PN_VAR_PERIODS_ALL does not reference any database object
PN.PN_VAR_PERIODS_ALL is referenced by following:
| Description: | Stores variable rent agreement information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_RENTS_ALL.LEASE_ID | PN_LEASES_ALL |
| PN_VAR_RENTS_ALL.TERM_TEMPLATE_ID | PN_TERM_TEMPLATES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_BKPTS_DET_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_BKPTS_HEAD_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_GRP_DATES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_LINES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_PERIODS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_PERIODS_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_RENT_DATES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_RENT_INV_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_RENT_SUMM_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
PN.PN_VAR_RENTS_ALL does not reference any database object
PN.PN_VAR_RENTS_ALL is referenced by following:
| Description: | Stores GL Calendar to be used and variable agreement related date frequencies. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_RENT_DATES_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
PN.PN_VAR_RENT_DATES_ALL does not reference any database object
PN.PN_VAR_RENT_DATES_ALL is referenced by following:
| Description: | Stores the calculated variable rent details for a period and for an invoice date. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_RENT_INV_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_RENT_INV_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_RENT_INV_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
| PN_PAYMENT_TERMS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
| PN_VAR_ABATEMENTS_ALL.VAR_RENT_INV_ID | PN_VAR_RENT_INV_ALL |
PN.PN_VAR_RENT_INV_ALL does not reference any database object
PN.PN_VAR_RENT_INV_ALL is referenced by following:
| Description: | Stores the calculated variable rent for a line item for a group date. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_RENT_SUMM_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_RENT_SUMM_ALL.VAR_RENT_ID | PN_VAR_RENTS_ALL |
| PN_VAR_RENT_SUMM_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_RENT_SUMM_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
PN.PN_VAR_RENT_SUMM_ALL does not reference any database object
PN.PN_VAR_RENT_SUMM_ALL is referenced by following:
| Description: | This table stores report dates of variable rent by group date. |
|---|
PN.PN_VAR_REPORT_DATES_ALL does not reference any database object
PN.PN_VAR_REPORT_DATES_ALL is referenced by following:
| Description: | This table stores templates containing default values for variable rent agreements. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_LINES_ALL.AGREEMENT_TEMPLATE_ID | PN_VAR_TEMPLATES_ALL |
| PN_VAR_CONSTRAINTS_ALL.AGREEMENT_TEMPLATE_ID | PN_VAR_TEMPLATES_ALL |
PN.PN_VAR_TEMPLATES_ALL does not reference any database object
PN.PN_VAR_TEMPLATES_ALL is referenced by following:
| Description: | This table stores information on variable rent records. |
|---|
PN.PN_VAR_TRX_DETAILS_ALL does not reference any database object
PN.PN_VAR_TRX_DETAILS_ALL is referenced by following:
| Description: | This table stores details of variable rent calculations |
|---|
PN.PN_VAR_TRX_HEADERS_ALL does not reference any database object
PN.PN_VAR_TRX_HEADERS_ALL is referenced by following:
| Description: | This table stores volume data that was modified during batch import. |
|---|
PN.PN_VAR_VOL_ARCH_ALL does not reference any database object
PN.PN_VAR_VOL_ARCH_ALL is referenced by following:
| Description: | Stores volume history related to a line item. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PN_VAR_VOL_HIST_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_VOL_HIST_ALL.PERIOD_ID | PN_VAR_PERIODS_ALL |
| PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID | PN_VAR_LINES_ALL |
| PN_VAR_VOL_HIST_ALL.GRP_DATE_ID | PN_VAR_GRP_DATES_ALL |
| PN_VAR_VOL_HIST_ALL.ACTUAL_GL_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PN_VAR_VOL_HIST_ALL.FOR_GL_ACCOUNT_ID | GL_CODE_COMBINATIONS |
PN.PN_VAR_VOL_HIST_ALL does not reference any database object
PN.PN_VAR_VOL_HIST_ALL is referenced by following:
| Description: | Interface table to contain batch information. |
|---|
PN.PN_VOL_HIST_BATCH_ITF does not reference any database object
PN.PN_VOL_HIST_BATCH_ITF is referenced by following:
| Description: | Interface table to contain batch lines information. |
|---|
PN.PN_VOL_HIST_LINES_ITF does not reference any database object
PN.PN_VOL_HIST_LINES_ITF is referenced by following:
APPS.PN_ACT_RENT_DETAILS_V is not referenced by any database object
APPS.PN_ADJUSTMENT_DETAILS_V is not referenced by any database object
APPS.PN_AEL_BILL_GL_V is not referenced by any database object
APPS.PN_AEL_PAY_GL_V is not referenced by any database object
APPS.PN_BUILDINGS_V is not referenced by any database object
APPS.PN_COMPANIES_V is not referenced by any database object
APPS.PN_COMPANY_SITES_V is not referenced by any database object
APPS.PN_CONTACTS_V is not referenced by any database object
APPS.PN_CONTACT_ASSIGNMENTS_V is not referenced by any database object
APPS.PN_CONTACT_ASSIGN_HISTORY_V is not referenced by any database object
APPS.PN_DISTRIBUTIONS_HISTORY_V is not referenced by any database object
APPS.PN_DISTRIBUTIONS_V is not referenced by any database object
APPS.PN_EXP_PAYMENT_ITEMS_V is not referenced by any database object
APPS.PN_FLOORS_V is not referenced by any database object
APPS.PN_FOR_RENT_DETAILS_V is not referenced by any database object
APPS.PN_GL_PERIOD_V is not referenced by any database object
APPS.PN_INDEX_EXCLUDE_TERM_V is not referenced by any database object
APPS.PN_INDEX_HISTORY_HEADERS_V is not referenced by any database object
APPS.PN_INDEX_HISTORY_LINES_V is not referenced by any database object
APPS.PN_INDEX_LEASES_V is not referenced by any database object
APPS.PN_INDEX_LEASE_CONSTRAINTS_V is not referenced by any database object
APPS.PN_INDEX_LEASE_PERIODS_V is not referenced by any database object
APPS.PN_INSURANCE_REQUIREMNTS_V is not referenced by any database object
APPS.PN_INSUR_REQUIRE_HISTORY_V is not referenced by any database object
APPS.PN_JE_CATEGORIES_V is not referenced by any database object
APPS.PN_LANDLORD_SERVICES_V is not referenced by any database object
APPS.PN_LANDLORD_SERVICE_HISTORY_V is not referenced by any database object
APPS.PN_LEASES_V is not referenced by any database object
APPS.PN_LEASE_CHANGES_V is not referenced by any database object
APPS.PN_LEASE_DETAILS_HISTORY_V is not referenced by any database object
APPS.PN_LEASE_DETAILS_V is not referenced by any database object
APPS.PN_LEASE_MILESTONES_V is not referenced by any database object
APPS.PN_LEASE_TRANSACTIONS_V is not referenced by any database object
APPS.PN_LOCATIONS_ITF_V is not referenced by any database object
APPS.PN_LOCATIONS_PUB_V is not referenced by any database object
APPS.PN_LOCATION_CONTACT_ASSIGN_V is not referenced by any database object
APPS.PN_LOCATION_FEATURES_V is not referenced by any database object
APPS.PN_LOCATION_PARKS_VL is not referenced by any database object
APPS.PN_LOC_ACC_MAP_HDR_V is not referenced by any database object
APPS.PN_LOC_ACC_MAP_V is not referenced by any database object
APPS.PN_NOTE_DETAILS_VL is not referenced by any database object
APPS.PN_NOTE_HEADERS_V is not referenced by any database object
APPS.PN_OFFICES_V is not referenced by any database object
APPS.PN_OPTIONS_HISTORY_V is not referenced by any database object
APPS.PN_OPTIONS_V is not referenced by any database object
APPS.PN_PAYMENT_ITEMS_V is not referenced by any database object
APPS.PN_PAYMENT_SCHEDULES_V is not referenced by any database object
APPS.PN_PAYMENT_TERMS_HISTORY_V is not referenced by any database object
APPS.PN_PAY_GROUP_BYS_V is not referenced by any database object
APPS.PN_PAY_GROUP_RULES_V is not referenced by any database object
APPS.PN_PBUILDING_V is not referenced by any database object
APPS.PN_PHONES_V is not referenced by any database object
APPS.PN_PLAND_V is not referenced by any database object
APPS.PN_PROPERTIES_V is not referenced by any database object
APPS.PN_RIGHTS_HISTORY_V is not referenced by any database object
APPS.PN_RIGHTS_V is not referenced by any database object
APPS.PN_SET_MILESTONES_VL is not referenced by any database object
APPS.PN_SET_TYPES_VL is not referenced by any database object
APPS.PN_SPACE_ALLOCATIONS_V is not referenced by any database object
APPS.PN_SPACE_ASSIGN_CUST_PUB_V is not referenced by any database object
APPS.PN_SPACE_ASSIGN_CUST_V is not referenced by any database object
APPS.PN_SPACE_ASSIGN_EMP_PUB_V is not referenced by any database object
APPS.PN_SPACE_ASSIGN_EMP_V is not referenced by any database object
APPS.PN_TENANCIES_HISTORY_V is not referenced by any database object
APPS.PN_TENANCIES_V is not referenced by any database object
APPS.PN_TERM_HISTORY_HEADER_V is not referenced by any database object
APPS.PN_TERM_TEMPLATES_V is not referenced by any database object
APPS.PN_TRX_LEASE_EXPENSE is not referenced by any database object
APPS.PN_TRX_LEASE_REVENUE is not referenced by any database object
APPS.PN_VAR_BKPTS_DET_V is not referenced by any database object
APPS.PN_VAR_BKPTS_HEAD_V is not referenced by any database object
APPS.PN_VAR_CONSTRAINTS_V is not referenced by any database object
APPS.PN_VAR_DEDUCTIONS_V is not referenced by any database object
APPS.PN_VAR_LINES_DATES_V is not referenced by any database object
APPS.PN_VAR_LINES_V is not referenced by any database object
APPS.PN_VAR_PERIODS_DATES_V is not referenced by any database object
APPS.PN_VAR_PERIODS_V is not referenced by any database object
APPS.PN_VAR_RENTS_V is not referenced by any database object
APPS.PN_VAR_RENT_ADJ_V is not referenced by any database object
APPS.PN_VAR_RENT_DATES_V is not referenced by any database object
APPS.PN_VAR_RENT_DETAILS_V is not referenced by any database object
APPS.PN_VAR_RENT_INV_V is not referenced by any database object
APPS.PN_VAR_RENT_SUMM_V is not referenced by any database object
APPS.PN_VAR_TERMS_V is not referenced by any database object
APPS.PN_VAR_VOL_HIST_V is not referenced by any database object
APPS.PN_XLA_EXTRACT_HEADERS_V is not referenced by any database object
APPS.PN_XLA_EXTRACT_LINES_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |