Search Results pn_company_sites_all




Overview
Explore in AI Chat

Overview

The PN_COMPANY_SITES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It serves as the central repository for storing site-level information associated with a service provider, also known as a company. A "company site" represents a specific physical location, such as an office, branch, or facility, from which a service provider operates. This table is essential for managing the detailed location data required for lease administration, service billing, and communication within the context of property and lease management. As an ALL table, it is designed to support the EBS Multi-Org architecture, storing data partitioned by Operating Unit (ORG_ID).

Key Information Stored

The table's primary purpose is to link a service provider (company) to a specific address and define site-specific attributes. The most critical columns include the primary key, COMPANY_SITE_ID, which uniquely identifies each site record. The COMPANY_ID column is a foreign key linking the site to its parent entity in the PN_COMPANIES_ALL table. The ADDRESS_ID column is a foreign key linking to the PN_ADDRESSES_ALL table, which holds the detailed postal address for the site. Other typical columns in such a structure would include site name, site number, status (e.g., ACTIVE, INACTIVE), and the standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). The ORG_ID column is implicitly present to enforce data security across operating units.

Common Use Cases and Queries

This table is primarily queried to retrieve all operational sites for a given service provider or to find the specific address of a site for correspondence or billing. A common reporting requirement is to generate a list of all active company sites within a particular operating unit. A typical SQL pattern involves joining to the companies and addresses tables for a complete view.

  • Sample Query: To retrieve site details for a specific company:
    SELECT pcs.site_name, pcs.site_number, pa.address_line1, pa.city, pa.state
    FROM pn_company_sites_all pcs,
    pn_addresses_all pa
    WHERE pcs.company_id = :p_company_id
    AND pcs.address_id = pa.address_id
    AND pcs.org_id = :p_org_id
    AND pcs.status = 'ACTIVE';
  • Use Case: When generating a lease invoice that bills for services provided from a specific vendor site, the application references this table to pull the correct site identifier and its associated address for the invoice header or remit-to details.

Related Objects

The PN_COMPANY_SITES_ALL table sits at the center of a key relationship hierarchy within Property Manager. Based on the documented foreign key constraints:

  • Parent Tables: It is a child of PN_COMPANIES_ALL (via COMPANY_ID) and PN_ADDRESSES_ALL (via ADDRESS_ID).
  • Child Tables: It is a parent to several tables that store information associated with a specific site:

This structure ensures that all contacts and their assignments are correctly scoped to a precise physical location of the service provider.