Search Results pn_companies_all




Overview
Explore in AI Chat

Overview

The PN_COMPANIES_ALL table is a core master data table within the Oracle E-Business Suite Property Manager (PN) module. It serves as the central repository for storing information pertaining to service providers, which are external entities that provide services related to property management, such as lessors, lessees, brokers, insurance companies, and maintenance vendors. This table is fundamental for establishing and managing the business relationships and contractual obligations that are central to property portfolio administration. As an "ALL" table, it is partitioned by the SET_OF_BOOKS_ID, enabling it to store data for multiple operating units within a single installation, which is a standard design pattern for multi-org capable tables in Oracle EBS.

Key Information Stored

The table's primary key is COMPANY_ID, which uniquely identifies each service provider record. While the full column list is not detailed in the provided metadata, standard columns for such a master table typically include COMPANY_NAME, COMPANY_NUMBER, and the critical PARENT_COMPANY_ID, which establishes a hierarchical relationship between companies within the same table. Other common attributes would capture the company's status, type (e.g., lessor, vendor), contact details, and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). The SET_OF_BOOKS_ID column is also a key structural attribute that enables the multi-org partitioning of data.

Common Use Cases and Queries

This table is primarily accessed to support the management of lease agreements and service contracts. Common business scenarios include generating a list of all active lessors for a specific operating unit, identifying the hierarchical structure of a corporate lessee, or selecting vendors for a property maintenance request. A typical query pattern involves joining to related tables to get a complete view of a provider. For example, to retrieve a company and its primary address, one might join to PN_COMPANY_SITES_ALL. A basic reporting query to list companies would follow the pattern: SELECT company_id, company_name, company_number FROM pn_companies_all WHERE set_of_books_id = :sob_id AND status = 'A' ORDER BY company_name. This table is also critical for data validation in transactional forms and for integration with other modules like Payables and Purchasing.

Related Objects

The PN_COMPANIES_ALL table maintains several key relationships within the Property Manager schema, as documented by its foreign key constraints. It has a recursive relationship with itself via the PARENT_COMPANY_ID column, allowing for organizational hierarchies. The table is the primary parent for the following key transactional and setup tables:

  • PN_COMPANY_SITES_ALL: Links companies to their physical or administrative addresses via COMPANY_ID.
  • PN_CONTACT_ASSIGNMENTS_ALL: Associates specific contacts with a company using COMPANY_ID.
  • PN_CONTACT_ASSIGN_HISTORY: Tracks historical changes to contact assignments for a company, also linked by COMPANY_ID.
These relationships indicate that PN_COMPANIES_ALL is a foundational source of data for managing service provider locations, contacts, and their assignment history throughout the lease lifecycle.