Search Results amv_vendor_keys

Overview

The AMV_VENDOR_KEYS table is a core data object within the Marketing Encyclopedia System (MES) module of Oracle E-Business Suite (EBS). Its primary function is to manage the relationship between marketing content items, known as "stocks," and their external content providers or vendors. The table acts as a junction, storing a unique key identifier for each vendor associated with every stock item registered in the AMV_STOCKS table. This structure is essential for tracking content provenance, managing vendor-specific metadata, and supporting content licensing and sourcing workflows within the MES application.

Key Information Stored

The table's structure is designed to link vendor, party, and stock information. The primary and foreign key columns are of particular importance. The VENDOR_KEY_ID column serves as the table's unique primary key. The STOCK_ID column is a foreign key that links each record to a specific content item in the AMV_STOCKS table. The VENDOR_ID column is a foreign key referencing the PO_VENDORS table, connecting the record to the EBS procurement vendor master. Finally, the PARTY_ID column is a foreign key referencing the HZ_PARTIES table in the Trading Community Architecture (TCA) model, linking the vendor to its standardized party definition. This dual-link to both procurement and TCA entities provides integration flexibility across the EBS suite.

Common Use Cases and Queries

A primary use case is generating reports on content sourcing, such as listing all stocks provided by a specific vendor. This is critical for vendor performance analysis and content audit trails. Application logic frequently queries this table to validate vendor associations when uploading or publishing new marketing content. A typical query pattern involves joining AMV_VENDOR_KEYS with AMV_STOCKS and vendor master tables:

• SELECT s.stock_name, v.vendor_name FROM amv_vendor_keys vk, amv_stocks s, po_vendors v WHERE vk.stock_id = s.stock_id AND vk.vendor_id = v.vendor_id AND v.vendor_id = :p_vendor_id;

Another common operation is inserting a new record when a new vendor-key association is established for a stock during content setup.

Related Objects

AMV_VENDOR_KEYS is centrally connected to several key EBS objects. Its primary relationship is with the AMV_STOCKS table, which holds the master definition of marketing content items. For vendor information, it has two critical foreign key dependencies: the PO_VENDORS table from the Purchasing module and the HZ_PARTIES table from the Trading Community Architecture (TCA) foundation. These relationships ensure vendor data consistency across procurement, customer management, and marketing content systems. The table is protected by the primary key constraint AMV_VENDOR_KEYS_PK on the VENDOR_KEY_ID column.