Search Results po_vendor_contacts




Overview
Explore in AI Chat

Overview

The PO_VENDOR_CONTACTS table is a core data object within the Oracle E-Business Suite Purchasing (PO) module, specifically for Release 12.1.1 and 12.2.2. It serves as the central repository for storing detailed contact information associated with supplier sites. This table is fundamental for procurement operations, enabling communication and interaction with specific individuals at vendor locations. Its primary role is to maintain a structured list of contacts, which is then referenced throughout the purchasing lifecycle—from sourcing and requisitioning to purchasing and payment processes—ensuring accurate routing of documents and correspondence.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is VENDOR_CONTACT_ID, a unique identifier for each contact record. Based on standard Oracle EBS Purchasing data model knowledge, this table typically stores comprehensive contact details. Key columns often include the VENDOR_SITE_ID (linking the contact to a specific supplier address), the contact's first and last name, title, area code, phone number, fax number, email address, and functional roles (e.g., "Buyer," "Accounts Payable"). It also contains control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing purposes.

Common Use Cases and Queries

This table is central to reporting and operations involving supplier communications. Common use cases include generating contact lists for specific vendor sites, populating contact information on purchase orders and RFQs, and supporting approval workflows. A typical query might join PO_VENDOR_CONTACTS with PO_VENDOR_SITES_ALL and PO_VENDORS to create a comprehensive supplier directory report. For instance, to find all contacts for a vendor site, one might use: SELECT pvc.first_name, pvc.last_name, pvc.email_address FROM po_vendor_contacts pvc WHERE pvc.vendor_site_id = <site_id>;. The foreign key relationship with OKL_CURE_REPORTS, as noted in the user's search context, indicates this table is also used by the Oracle Lease and Finance Management (OKL) module to associate vendor contacts with specific cure reports.

Related Objects

As indicated by the foreign key metadata, PO_VENDOR_CONTACTS is a heavily referenced table with significant integration across modules. Its primary relationship is with PO_VENDOR_SITES_ALL, where VENDOR_SITE_ID originates. Within Purchasing, it is referenced by PO_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_RFQ_VENDORS, among others. Crucially, it has cross-module dependencies, including integration with OKL_CURE_REPORTS in Lease Management and with several IGC_CC* tables (IGC_CC_HEADERS, etc.), which are part of the Public Sector Procurement for Contracts and Grants functionality. This wide range of foreign keys underscores its role as a shared master data source for vendor contact information enterprise-wide.